Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
PBI_dv
Frequent Visitor

Compare measure last year and add status

Hello,

I need to compare an amount like Revenue the selected year N with the previous year related N-1 and add a status with this condition if Revenue N = 0 and Revenue N-1 >0 then "inactive" for a main fact table and for 3 Others fact table, then I need to Display the result on a single Matrix.

                 Nb active |  Nb inactive | Nb New

Year N.    | 

Year N-1 | 

What is the best technique for reach this result ?

Please could you help me ?

 

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.