Compare this month with previous month in a matrix with multiple months

[Martin74]

Hello Guys,

I need some help with following (i can't figure out by myself). I import some data from a SQL server, put this in a matrix where per month the maximum value is shown by month. I want to show the difference for the last month by the previous month, so only one additonal column in the matrix on the end of it.

DataFile: https://www.dropbox.com/s/ylxnnrpxt2vq4xu/data.csv?dl=0

BI File: https://www.dropbox.com/s/twikjwox0yq6bok/PBI%20Test.pbix?dl=0

[v-jayw-msft · Accepted solution]

Hi @Martin74 ,

Please check the measure.

Measure = CALCULATE(MAX(data[ActualValue]),FILTER(ALL(data),data[UTCDateTime].[Year]=SELECTEDVALUE(data[UTCDateTime].[Year])&&data[UTCDateTime].[MonthNo]=SELECTEDVALUE(data[UTCDateTime].[MonthNo])-1&&data[PointName]=SELECTEDVALUE(data[PointName])))-MAX(data[ActualValue])

Result would be shown as below.

Best Regards,

Jay

[Martin74]

Thanks Jay, this helps me a lot. I figured out by doing it another (messy) way. This much more cleaner DAX. I appriciate your help.

[MattAllington]

Read my articles here. 

https://exceleratorbi.com.au/dax-time-intelligence-beginners/

and here

https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/

first you need to write your 2 measures (first article), then you need to create the table you need (second article)