Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamically compare measures

Hi all Simply put - I need to dinamically compare (percentage between the two) two different matrix tables with measures on it as I change the period. Have wandered through a variety of topics sea...
Need Help
Show and Tell
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    According to your description, I can roughly understand your requirement, I think you can achieve this using Matrix and “Edit interactions”, you can try my steps:

    1. Create two same slicers and two same matrices, place them like this:

     

    1. Go to the “Edit interactions”, set the interaction for the two slicers like this:

     

    And you can compare the data as what you want, like this:

     

    You can download my test pbix file below

     

    If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , 1. if want to period one period with another standard period, then you can use time intelligence

 

 

examples

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
next month Sales = CALCULATE(SUM(Sales[Sales Amount]),nextmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum('Table'[total hours value]),previousmonth('Date'[Date]))

 

 

this can 2 months behind or 3.

 

2. But you want to select two 2 periods and compare, you need an additional date table to refer

How to use two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak

Thanks for the reply.

 

Apparently I can't escape the fact I will need to create one additional measure for comparing different periods. In your first proposed solution, I'd need to create those additional measures for all of my 15 measures, is that right?

 

I have around ~15 different measures (Expense X per kilo) which I need to compare from one period to another.