Forum Discussion
Help to create DAX formula
Hi Everyone, Could you please how to achive below Logic using DAX Measure in Power Bi Desktop. IFNULL(SUM ( IF IsFuture = 0 THEN [Projected] ELSEIF [IsFuture] = 1 AND [CalendarQuarter]...
Hello Anonymous,
Try this and say me if it works !
Column=
VAR __Hope = IF([IsFuture] = 0;[Projected]; IF(AND(AND([IsFuture] = 1;[Calendar Quater] = RIGHT([Forecast Scenario];1));[Is Lastest Forecast] = 1);[Projected];[Forecast]))
VAR __Help = IF(ISBLANK(__Hope);0;__Hope)
VAR __You = SUM([Forecast])
RETURN
DIVIDE(__Help;__You)
Regards,
Bastien
Hello Anonymous,
Try this and say me if it works !
Column=
VAR __Hope = IF([IsFuture] = 0;[Projected]; IF(AND(AND([IsFuture] = 1;[Calendar Quater] = RIGHT([Forecast Scenario];1));[Is Lastest Forecast] = 1);[Projected];[Forecast]))
VAR __Help = IF(ISBLANK(__Hope);0;__Hope)
VAR __You = SUM([Forecast])
RETURN
DIVIDE(__Help;__You)
Regards,
Bastien