Forum Discussion

Sania-F's avatar
Sania-F
Resolver I
2 years ago

DAX modification help needed

HI All, Please help in getting expected data.   I have  date table with columns [isEndOfQuarter] with values yes, no and [isCurrentFiscalYear] with values yes, no. I have a time-period table wi...
DAX
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello Sania-F,

 

Can you please try this streamlined version of your measure:

 

Revised Rev Plan SF2 = 
VAR IsCurrentFY = SELECTEDVALUE(DimDate[iscurrentfiscalyear]) = "Yes"
VAR IsEndOfQuarter = SELECTEDVALUE(DimDate[isendofquarter]) = "Yes"
VAR LatestLoadDate = MAX(factemt[LoadDateKey])
RETURN
    IF (
        IsEndOfQuarter,
        SUM(factemt[Value]),
        IF (
            IsCurrentFY,
            CALCULATE(
                SUM(factemt[Revenue Plan ($)]) / 1000,
                ALLSELECTED(DimDate),
                DimDate[iscurrentfiscalyear] = "Yes",
                DimDate[LoadDateKey] = LatestLoadDate
            ),
            BLANK()
        )
    )