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

Flo95 

Yes, measures within measures should also work

Flo95's avatar
Flo95
Frequent Visitor
2 years ago

Hello az38 

 

I tried it this way now:

But as you can see they all should be in Dunning Level 4, because Today we have 2024 and all of this orders are from 2023. 

 

So it doesnt switch from Dunning Level 1 to Dunning Level 2, Level 3 and Level 4. Do you understand?

 

Many many thanks again for your help!