If formula

[SteenSoernesen]

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 [Aflyst stop] "calcelled stop" could be blank if trips have driven from terminus to terminus.

In Excel you can use "" to indicate an empty cell. Could that also be done in Power Bi

[Cookistador · Accepted solution]

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")

)

[SteenSoernesen]

Thank you.