Forum

Hi Danielle, These calculations would normally be done in Power Pivot using the date time intelligence functions, not Power Query. Mynda

Hi Linda, Please upload a sample file in Excel (just a small sample with enough data to illustrate the scenario). Please also give an example of th...

Hi Yusuf, Welcome to our forum! This is a known limitation. Imke provides a workaround here. Mynda

Hi Lea, Please see file attached. Mynda

Hi Sid, You can use this formula: = SUMX ( VALUES ( Table2[Program Name] ), CALCULATE ( DISTINCTCOUNT ( Table2[Supplier] ) ) ) See a...

Hi Moriel, Thanks for sharing your file. Unfortunately, the source data is somewhere else, so when I open the query I get an error. However, I used...

Hi Hitesh, Use Power Query to get the data from the separate sheets, then unpivot it and summarise it with a PivotTable. Mynda

Yes, you can use the layout as you have it. The query will automatically pick up any new data as long as it's stored in the Excel Tables in each month...

Hi Loki, Welcome to our forum! The problem you're having using formulas is that your data is not set up in the correct layout to support them. You ...

Hi Moriel, Your file didn't get uploaded. After selecting the file you need to click the 'start upload' button and wait for the green text notifica...

Hi Lea, Thanks for clarifying with the screenshot. You can add a custom column that says if = null then [1] else null and then fill down the new c...

Hi Jesse, Welcome to our forum! Please upload a sample file so we can better understand your data and needs. Mynda

Hi Ndjib, Welcome to our forum! What exactly do you mean by 'link the report to the graph'? What report? If you want a dynamic label/chart ti...

Hi Pieter, It won't make any difference if you create this as a custom function, the steps will be the same therefore there won't be any efficiency...

Hi Jiri, Your data is in the wrong format. You should never have the columns represent a separate month. This data needs to be unpivoted. From ther...