Create a measure based on date filter slicer

[rschaudhr]

I have a dashboard with Table visualization and has a date filter. I want to create a calcutate measure based on the end date of the date slicer. 

So, if my date range in date slicer is from 7/25/2019 to 8/19/2019, then the measure should only take value from 8/19/2019. Further more, I have a measure already and would like to incorporate it in the measure if possible. The measure is as follows:

Calculate = divide(sum([EOP MV]), CALCULATE(SUM([EOP MV]),ALLEXCEPT(IPA,Date,[Manager])))

I hope this is enough information. 

Thank you,

RC

[jdbuchanan71 · Accepted solution]

Hello @rschaudhr 

Give this a try.

Measure =
VAR _LastDate =
    LASTDATE ( Dates[Date] )
RETURN
    CALCULATE (
        DIVIDE (
            SUM ( [EOP MV] ),
            CALCULATE ( SUM ( [EOP MV] ), ALLEXCEPT ( IPA, Date, [Manager] ) )
        ),
        _LastDate
    )

[jdbuchanan71 · Accepted solution]

Hello @rschaudhr 

Give this a try.

Measure =
VAR _LastDate =
    LASTDATE ( Dates[Date] )
RETURN
    CALCULATE (
        DIVIDE (
            SUM ( [EOP MV] ),
            CALCULATE ( SUM ( [EOP MV] ), ALLEXCEPT ( IPA, Date, [Manager] ) )
        ),
        _LastDate
    )

[rschaudhr]

Unfortunately, this did not work

[jdbuchanan71]

@rschaudhr 

You will have to give a bit more information.  Did you receive an error or an unexpected result?  Can you share some of your sample data in a format that can be copied (not a screen shot) and show us how your model is layed out and what the expected result is?

[rschaudhr · Accepted solution]

Actually, I am misspoken. Your solution did work. Thank you for this. 

[kentyler]

Here is a post about creating the measure that references a date range slicer

https://community.powerbi.com/t5/Desktop/Filter-data-using-date-range-from-slicer/td-p/483072