How to get the minx value of the last 12 months of a measure.

[ilyakoslov]

Hello guys,

so I would like to know how do I get the minx value of a measure from the last 12 months and make it dynamic, based on what date the user chooses. Let's say he picks december, power bi would look 12 months before that for the time where the measure was in it's lowest value. 

I have a Calendar table, a cost table and a revenue table. The measure of which I want to show the user is the division between both. 

So Measure[% CR] divides cost by revenue. And I would like to show the user the value of this measure when it was on it's lowest. 

Can someone help? Thanks!!

[FreemanZ]

You would need DATESINPERIOD, as the filter argument of your calculation. check this

https://learn.microsoft.com/en-us/dax/datesinperiod-function-dax

[ilyakoslov · Accepted solution]

I solved it check it out

PMR Ref =

    MINX (

        FILTER (

            ALL ( 'Calendario' ),

            'Calendario'[Data] >= DATEADD ( 'Calendario'[Data], -12, MONTH )

                && 'Calendario'[Data] <= MAX ( 'Calendario'[Data] )

        ),

        [PMR]

    )

[FreemanZ]

congratulations. Harnessing the flexibility of DATEADD, you can solve most of the Time Intelligence relevant issue.