Forum Discussion

mark_carlisle's avatar
mark_carlisle
Icon for Advocate IV rankAdvocate IV
6 years ago
Solved

Date What If Parameter

I've created 3 What If parameters Date - Year, Date - Month, and Date - Day.   I have a two measures already to calculate the total cases pre and post a date, these are;     Total Cases (Post 1...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Try:

     

    Total Cases (Pre 16/03) = 
VAR __Year = SELECTEDVALUE([Date - Year Value])
VAR __Month = SELECTEDVALUE([Date - Month Value])
VAR __Day = SELECTEDVALUE([Date - Day Value])
CALCULATE (
    [Total Cases(Distinct)],
    ALL ( 'Calendar' ),
    FILTER (
        'Calendar',
        AND (
            'Calendar'[Date] >= DATE ( 2020, 01, 01 ),
            'Calendar'[Date] < DATE ( __Year, __Month, __Day )
        )
    )
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Try:

 

Total Cases (Pre 16/03) = 
VAR __Year = SELECTEDVALUE([Date - Year Value])
VAR __Month = SELECTEDVALUE([Date - Month Value])
VAR __Day = SELECTEDVALUE([Date - Day Value])
CALCULATE (
    [Total Cases(Distinct)],
    ALL ( 'Calendar' ),
    FILTER (
        'Calendar',
        AND (
            'Calendar'[Date] >= DATE ( 2020, 01, 01 ),
            'Calendar'[Date] < DATE ( __Year, __Month, __Day )
        )
    )
)