Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help measures in Matrix Visual

Experts, Need your help on the below secnario. 1. I have one measure and dates always fetches only two dates ex: June 2023 & Dec 2022. If I put my measure in matrix visual and keep the dates column ...
DAX Commands and Tips
Matrix Visualisation
  • WinterMist's avatar
    WinterMist
    3 years ago

    Anonymous 

     

    The following should deliver the result you are looking for.

     

    NOTE: I have left some of the "middle steps" measures in the table visual below only for readability.  But they can be removed to match what you have shown in your desired results screenshot.

     

     

    First, build the base measures that will be used in the other calculations:

     

     

     

    Second, build the measures that calculate each metric for the PP (Previous Period):

     

     

     

     

    Finally, build the measures that get the difference between the current values & the PP (Previous Period) values:

     

     

    Hope this is helpful to you.

     

    Regards,
    Nathan

WinterMist's avatar
WinterMist
Impactful Individual
3 years ago

Anonymous 

 

The following should deliver the result you are looking for.

 

NOTE: I have left some of the "middle steps" measures in the table visual below only for readability.  But they can be removed to match what you have shown in your desired results screenshot.

 

 

First, build the base measures that will be used in the other calculations:

 

 

 

Second, build the measures that calculate each metric for the PP (Previous Period):

 

 

 

 

Finally, build the measures that get the difference between the current values & the PP (Previous Period) values:

 

 

Hope this is helpful to you.

 

Regards,
Nathan