Forum Discussion

tamilkumaran's avatar
tamilkumaran
Frequent Visitor
6 years ago

Calculate percentage difference between two column-individual row and difference of column for month

I have a requirement to show the percentage difference between two columns dynamically based on user selection in filter. I am providing 3 individual filters to user as Slicer  - Region, Country, Mo...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

tamilkumaran , not very clear, you can use time intelligence and date table

 

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

or diff between two sales
Measure = divide(SUM('Sales '[Sales 2]),SUM('Sales '[Sales 1]))

 

 

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