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.
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.
Go to Solution.
@isaac152, Use time intelligence with the date. if you don't have it, create one as
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://email@example.com/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-functionshttps://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://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.
Proud to be a Super User!
View solution in original post
Is the pivot table your rawdata or it's the visual table in powerbi? What's your rawdata looks like?
@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?
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.