Forum Discussion

RSOSA's avatar
RSOSA
New Member
2 years ago
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...
Need Help
  • kiran_jadhav's avatar
    kiran_jadhav
    2 years ago

    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 -1
    var todayscount =CALCULATE(SUM(TABLENAME[Repeatecaller]),TABLENAME[WKN]=todaysdate )
    var previousdaycount=CALCULATE(SUM(TABLENAME[Repeatecaller]),TABLENAME[WKN]=previousdaydate)

    return
    IF(previousdaycount=BLANK(),BLANK(),todayscount -previousdaycount)

    Use a table or matrix visual





  • kiran_jadhav's avatar
    kiran_jadhav
    2 years ago

    If you have full date you can replace it with WKN column.

     

    If previous solution works for you please mark as solution.

     

kiran_jadhav's avatar
kiran_jadhav
Frequent Visitor
2 years ago

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 -1
var todayscount =CALCULATE(SUM(TABLENAME[Repeatecaller]),TABLENAME[WKN]=todaysdate )
var previousdaycount=CALCULATE(SUM(TABLENAME[Repeatecaller]),TABLENAME[WKN]=previousdaydate)

return
IF(previousdaycount=BLANK(),BLANK(),todayscount -previousdaycount)

Use a table or matrix visual





  • RSOSA's avatar
    RSOSA
    New Member
    2 years ago

    It works! thank you so much, but, a follow-up question, what if I want this same, but apply for month and week whenever I apply any drill down?

     

     

     

    Here is what I got so far, It works perfectly when it comes to a day, but as you can see, the week is showing the last value of the day and is not comparing to the previous week, same for the month.

     

    Is there a way to do so?