topic Excel formula to DAX Calculate column in DAX Commands and Tips

Excel formula to DAX Calculate column

Anonymous — Fri, 19 Aug 2022 12:44:54 GMT

Hi,

The below is the Excel Formula Now I want to convert into DAX Calculated column. Please Suggest on this one

IF [ "Date1" - MAX ( "Date2";" Date1";" Date3";"Date4") ] > 1 THEN "0" ELSE "1"

Thanks

Re: Excel formula to DAX Calculate column

tamerj1 — Fri, 19 Aug 2022 13:01:00 GMT

Hi Anonymous

please try

= VAR Date1 = [Date1] VAR T1 = GENERATESERIES ( 1, 4, 1 ) VAR T2 = ADDCOLUMNS ( T1, "@Date", SWITCH ( [Value], 1, [Date1], 2, [Date2], 3, [Date3], 4, [Date4] ) ) VAR MaxDate = MAXX ( T2, [@Date] ) RETURN IF ( DATEDIFF ( MaxDate, Date1, DAY ) > 1, 1, 0 )

Re: Excel formula to DAX Calculate column

Anonymous — Mon, 22 Aug 2022 10:11:13 GMT

Hi Tamerj1,

When I am adding the above Dax Calculation in a new measure I am not able to get the Table and column name date1. any suggetions Please

Re: Excel formula to DAX Calculate column

tamerj1 — Mon, 22 Aug 2022 10:33:01 GMT

Hi Anonymous
For measure please try

= VAR Date1 = [Date1] VAR T1 = GENERATESERIES ( 1, 4, 1 ) VAR T2 = ADDCOLUMNS ( T1, "@Date", SWITCH ( [Value], 1, MAX ( [Date1] ), 2, MAX ( [Date2] ), 3, MAX ( [Date3] ), 4, MAX ( [Date4] ) ) ) VAR MaxDate = MAXX ( T2, [@Date] ) RETURN IF ( DATEDIFF ( MaxDate, Date1, DAY ) > 1, 1, 0 )