Forum

Check where the error occurs, and avoid error: #"Added Custom" = Table.AddColumn(#"Changed Type", "FetchData", each try Liste([Webseite]) otherwise...

Hi Linda, Why 11-Ruffle should be 115$? I know you mentioned last event, and that is Ruffle. But when you filter the table for 11-Ruffle, you will ...

Hi Franz, That should not be called "Cascading cost", it's tornading costs... Almost twisted my brains. I had to build a recursive function to g...

Not sure why you need a second grouping, my guess is you're not on the right direction. Grouping by 2 fields and keeping all the rows, then expanding ...

You said: i have cell in Excel where i have named range name : "MyNamedRange". Now you're saying that it's not a named range, it is a defined name...

Hi Corrie, Without proper data, there is no easy way, just workarounds, and there are chances to fail in specific scenarios. You can try this qu...

Hi, You can take a value from an excel named range just like you do for any table: = Excel.CurrentWorkbook(){[Name="namedrng"]}[Content] A ta...

Something like this? = Table.SelectRows(#"Changed Type", each ([DATE] > Date.AddDays(Date.From(DateTime.LocalNow()),-60)) and ([DATE...

17000 rows should not be a problem, should load fast enough. Looks like we have different perspectives, that's the reason for misunderstandings. I ...

Aravind Krishnakumar said The table about the date, is to be created using a blank query right? And just paste it? Sorry for not knowing what to do....

Hi Carlos, Where is the email address stored in the sheet? Not seeing any email in the screenshot you provided.

No worries Maree, we're here to help. Yes, instead of merging tables in power query, add related formula in power pivot to bring data from those ta...

Hi Maree, "In my attached data model example should I be "appending" (or is it merging?) the customer GroupView and AreaView to the CustomerView AN...

Hi Aravind, I was able to do a full refresh in under 1 minute, but I guess it's just the difference in computer performances. You are using powe...

Hi Aye, Duration is provided only in a few units, not year or months: You will have to convert days to years or months. 365/12 will give you t...