Forum Discussion
Tableau to DAX
Hi, I need help converting these two calculated fields from Tableau to DAX. Freeze Date IF ENDSWITH([Academic Period Id],'9') THEN DATEPARSE('MMM-dd-yyyy','Aug-15-'+LEFT([Academic Period Id],4)...
Anonymous Please try this:-
Resident at Freeze = IF ( [Resident Length] > 0 && [Academic Period Id] = 202009, "Y", IF ( [Resident Length] > 0 && [Resident Start Date] <= [Freeze Date] && [Resident End Date] >= [Freeze Date], "Y", "N" ) )
Samarth_18
Community Champion
Community ChampionHi Anonymous ,
If you could provide some sample data in text format(not a screenshot) with expected output then it would be more helpful but you could try this:-
Freeze Date =
VAR _endswith =
RIGHT ( [Academic Period Id], 1 )
VAR _startwith =
LEFT ( [Academic Period Id], 4 )
RETURN
IF (
_endswith = "9",
FORMAT ( DATE ( LEFT ( [Academic Period Id], 4 ), 08, 15 ), "MMM-dd-yyyy" ),
FORMAT ( DATE ( LEFT ( [Academic Period Id], 4 ), 01, 15 ), "MMM-dd-yyyy" )
)
Resident at Freeze =
IF (
[Resident Length] > 0
&& [Academic Period Id] = "202009",
"Y",
IF (
[Resident Length] > 0
&& [Resident Start Date] <= [Freeze Date]
&& [Resident End Date] >= [Freeze Date],
"Y",
"N"
)
)
For Resident at Freeze, it throws an error:
DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
- Samarth_18
Anonymous Please try this:-
Resident at Freeze = IF ( [Resident Length] > 0 && [Academic Period Id] = 202009, "Y", IF ( [Resident Length] > 0 && [Resident Start Date] <= [Freeze Date] && [Resident End Date] >= [Freeze Date], "Y", "N" ) )