Forum Discussion

Priyanka2's avatar
Priyanka2
New Member
8 years ago
Solved

Dynamic Measures based on filter selection

Hi Everyone,   This is Priyanka here. I've started working on Power BI recently. I'm new to it and has lots remaining to explore in it. I'm stuck in a scenario.Please if anyone can guide me. I ...
  • alexei7's avatar
    alexei7
    8 years ago

    Hi Priyanka,

     

    I think what you want to do is to create three measures:

     

    #1 sum of sales

    #2 sum of sales from month-1

    #3 sum of sales from month-2

     

    You could then put "month" as a field in the Power BI table and each of these three measures.

     

    #1 should be quite easy to do using the SUM function

    #2 and #3 - it'd be best to use CALCULATE with PARALLELPERIOD

     

    Hope that helps get you started!

     

    Alex

alexei7's avatar
alexei7
Continued Contributor
8 years ago

Hi Priyanka,

 

I think what you want to do is to create three measures:

 

#1 sum of sales

#2 sum of sales from month-1

#3 sum of sales from month-2

 

You could then put "month" as a field in the Power BI table and each of these three measures.

 

#1 should be quite easy to do using the SUM function

#2 and #3 - it'd be best to use CALCULATE with PARALLELPERIOD

 

Hope that helps get you started!

 

Alex