Forum Discussion
Solved
Difference of value between dates
Hello Everyone, I am a new user of PBI, and now I am struggling with a formula, hope someone can guide me on how to do it, Basically what I want to do is calculate de difference or growth be...
Hello Rsosa,
If you are having only days insted of full date in WKN column you can try below measure, only replace "TABLENAME" with Your table name%diff=var todaysdate = MAX(TABLENAME[WKN])var previousdaydate= todaysdate -1var todayscount =CALCULATE(SUM(TABLENAME[Repeatecaller]),TABLENAME[WKN]=todaysdate )var previousdaycount=CALCULATE(SUM(TABLENAME[Repeatecaller]),TABLENAME[WKN]=previousdaydate)returnIF(previousdaycount=BLANK(),BLANK(),todayscount -previousdaycount)
Use a table or matrix visualIf you have full date you can replace it with WKN column.
If previous solution works for you please mark as solution.
Can you share snap of your data model, Or dummy data if possible to share?