Measure Help

[alexbalazsalex]

Dears i would need your help for a measure : i have a table with sales by month , i created another table with dates which i linked many to one: than i created a formula to calculate prices ; Price = DIVIDE(sum('Price Evolution'[Amount]),sum('Price Evolution'[Pieces])) Than based on this i created the following: Price Base = CALCULATE([Price],filter('Price Evolution','Price Evolution'[Calender Year_Month]=[Previous Month] Where Previous Month = SELECTEDVALUE('Previous Month'[Previous Month]) so when i select a month from drop down it actively calculates price for that certain period. Than i want to show data by month as in below Pic with interaction broken to the drop down so it shows all months and what i would like is instead of Price by month to show the delta vs the price of the month i selected and PRice of the month. At this point if i use Price - Price Base it gives me 0 for all months Any ideas on this ? Thanks https://ibb.co/xDDkX26

[amitchandak]

@alexbalazsalex , for last month you can try time intelligence with date table

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]))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

[alexbalazsalex]

Hi @amitchandak 

Thanks for your quick reply,

This doesnt work for me as i want the difference not between the last month but the mont i selected.

Lets say i select price of Jan21, so the graph will show Jan21 price as 0 as its jan21-jan21, than we will have Feb21-Jan21, Mar21-Jan21, Apr21-Jan21 etc....

With the part of Jan to be chaned actively .

Thanks

Alex

[amitchandak]

@alexbalazsalex , Do you need to slicer to select the month and take diff ?

if yes, then refer, else share some example output

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg