Difference between previous mont and shop

[isaac152]

Hi, i ask a question few days ago and the answer works me very well for some things, but i need to understand how to do this.

I have a pivot table like this.

Shops	Year	Month	Amount
Shop1	2019	6	50
Shop1	2019	7	30
shop2	2019	6	40
Shop2	2019	7	20

And i want to make a Measure that make the difference between shop amount by months.

So measure will be like

Shop1 2019 7 20

Shop2 2019 7 20

And go on with multiple shops and differents years and months.

I search for youtube but only found with one shop, so the code works but not for me.

I understand this seems like asking to much, but i just trying my best to understand this. Sorry.

[amitchandak · Accepted solution]

@isaac152, Use time intelligence with the date. if you don't have it, create one as

Date: date([year],[month],1)

Example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
last MTD (complete) Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value =  CALCULATE(sum('table'[total hours value]),previousmonth('Date'[Date]))

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

To get the best out of the weather intelligence feature. Make sure that you have a date calendar and that it has been marked as the date in the model view. Also, join her with the date column of her made/s. See:
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my Time Intelligence webinar can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...


We appreciate your congratulations.

[isaac152]

@amitchandak Hi and thanks for asnwer me, your code was right and works. But i have another question if you dont mind. Can i make this measure called "difference" become a colum? because i dont need variation with other things. Is this possible?

[ryan_mayu]

@isaac152 

Is the pivot table your rawdata or it's the visual table in powerbi? What's your rawdata looks like?