I am fairly new to query and power pivot, but I have now been able to consolidate a couple of Excel data tables into a single database, using power query. Using power pivot I am able to run a daily report, as well as a monthly report. The daily reports have an actual percentage in the data. In the Power pivot table, once I filter per month, it wants to naturally either sum or average these values, which does not make sense, I am interested in the last value for the month, and the difference between this and the previous end of month value. i.e. the percentage change over the month.

I have tried using a calculated field to get the value for the last reported value for the month, but I am completely hopeless with DAX formulas for now...

My two questions are:

- How can I get Power pivot to consolidate the percentages in the month filter, into the last value of the month?
- If I need to do this outside the power pivot report, then how do I pull the correct val
- ues out of the power pivot into a dashboard report?