Forum Discussion
Diff with previous date
Hi guys! Can't get my new column or measure to calculate the value in column "PrevRows" in Power Bi. I want to show the customer how tables grow in the databse between the dates. Hope you ca...
Thanks for your help.
I have solved it after reading this (https://community.powerbi.com/t5/Desktop/Find-value-for-first-and-last-date-by-person/m-p/62016).
Regards
Tobias
Diff = CALCULATE(SUM([Count of rows]),FILTER(Table,[What report] = "ThisReport")) - CALCULATE(SUM([Count of rows]),FILTER(Table,[What report] = "PrevReport"))
Put Table column and this measure into a table.