Forum Discussion
How do I get the difference of balances between dates?
Hi,
Create a Calendar Table and a retionship (Many to One and Single) from the ProdDate column of your Data Table to the Date column of the Calendar Table. To your slicer, drag the Date column from the Calendar Table and select 2 dates. Write these measures
Total = sum(Data[Amount])
Total on first date = calculate([Total],datesbetween(Calendar[date],min(calendar[date]),min(calendar[date])))
Total on second date = calculate([Total],datesbetween(Calendar[date],max(calendar[date]),max(calendar[date])))
Variance = [Total on first date]-[Total on second date]
Hope this helps.
Resident RockstarHi,
As far as I can see, you are using implicit measures, and to do what you want you need to use explicit measures.
I did a quick example in my pbi desktop and have this results:
I'm using this two measures:
It returns this. I want the 116,899.82 to show up in the card but it shows the grand total instead in the card which is way off by the way.