cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmalrajRRD1 Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Subtracion

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 

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Subtracion

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 

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |