Forum Discussion
Solved
If formula
I'm trying to make a dax if formula where there is another if formula mixed in. IF([Aflyst stop]="", "Kørt",IF([Aflyst stop] = [Antal stop], "aflyst", "Delaflyst")) My main problem is that [...
Hello SteenSoernesen
In Power BI, a blank is not an empty string.Isblank() should help you to solve this issue:
Status =IF(
ISBLANK([Aflyst stop]),"Kørt",
IF([Aflyst stop] = [Antal stop], "Aflyst", "Delaflyst"))
Cookistador
Super User
Super UserHello SteenSoernesen
In Power BI, a blank is not an empty string.
Isblank() should help you to solve this issue:
Status =
IF(
ISBLANK([Aflyst stop]),
"Kørt",
IF([Aflyst stop] = [Antal stop], "Aflyst", "Delaflyst")
)
Thank you.
