Forum Discussion

nesrine's avatar
nesrine
Frequent Visitor
7 years ago
Solved

Variations with specific dates

Hello !  i' looking to calculate the variation between two values by week. So if i have a coloun of date, i need to know the variation every week and be able to show it in my dashboard filtrerd by w...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi nesrine,

     

    If you want to calculate the Evolution, it seems that you want to calcuate the difference in one column based on date. You could refer to the fomula below.

     

    Column =
VAR tem =
    CALCULATE (
        MAX ( 'Table2'[NB app] ),
        FILTER ( 'Table2', EARLIER ( 'Table2'[Date] ) > 'Table2'[Date] )
    )
RETURN
    'Table2'[NB app]
        - IF ( tem = BLANK (), 'Table2'[NB app], tem )

     

     

    Best  Regards,

    Cherry

nesrine's avatar
nesrine
Frequent Visitor
7 years ago

Hello,

yes, in fact it's not clear. 

so my output is the coloun evolution, i want to show it in my dashboard every time i choose a date 

 

thank you,

best regards,

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi nesrine,

 

If you want to calculate the Evolution, it seems that you want to calcuate the difference in one column based on date. You could refer to the fomula below.

 

Column =
VAR tem =
    CALCULATE (
        MAX ( 'Table2'[NB app] ),
        FILTER ( 'Table2', EARLIER ( 'Table2'[Date] ) > 'Table2'[Date] )
    )
RETURN
    'Table2'[NB app]
        - IF ( tem = BLANK (), 'Table2'[NB app], tem )

 

 

Best  Regards,

Cherry