Forum Discussion

Flo95's avatar
Flo95
Frequent Visitor
2 years ago
Solved

IF Function

Hello everyone,   i need a Measure for the following Example: - The "Dunning Level" Column needs to be filled with the measure - If "Dunning Level 1" >= Todays Date         --> "Dunning Level" sh...
Need Help
  • Flo95's avatar
    Flo95
    2 years ago

    I solved the problem with the following code:

    Dunning Level =
    SWITCH(
            TRUE(),
            TODAY() >= [Dunning Level 4], "Level 4",
            TODAY() >= [Dunning Level 3], "Level 3",
            TODAY() >= [Dunning Level 2], "Level 2",
            TODAY() >= [Dunning Level 1], "Level 1",
            "N/A"
        )
az38's avatar
az38
Community Champion
2 years ago

Hi Flo95 

I would suggest you need a calculated column, but not a measure

 SWITCH(
		TRUE(),
		[Dunning Level 1] >= TODAY(), "Level 1",
		[Dunning Level 2] >= TODAY(), "Level 2",
		[Dunning Level 3] >= TODAY(), "Level 3",
		[Dunning Level 4] >= TODAY(), "Level 4",
		"N/A"
	)