Forum Discussion

AmalrajRRD1's avatar
AmalrajRRD1
Helper II
9 years ago
Solved

Subtracion

Hi all, 

         I did subtraction calculation from current year to previous year .I have Jan to Dec data . Now my question is i want to show the value only difference between Dec to Nov . I don t want any others variance . 

 

Is there possible to do in Power bi Desktop.

 

Thanks

Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi AmalrajRRD1,

     

    I think it is possible and it will be help if share some sample data of your data structure.

     

    It might be like:

    Result= Calculate([DiffMeasure],FIlter(All(Calendar),MONTH([Date])>=11))

     

    Regards,

    Xiaoxin Sheng 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi AmalrajRRD1,

     

    I think it is possible and it will be help if share some sample data of your data structure.

     

    It might be like:

    Result= Calculate([DiffMeasure],FIlter(All(Calendar),MONTH([Date])>=11))

     

    Regards,

    Xiaoxin Sheng