Forum Discussion

SteenSoernesen's avatar
SteenSoernesen
Frequent Visitor
6 months ago
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 [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's avatar
    Cookistador
    6 months ago

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

    )

3 Replies

  • Cookistador's avatar
    Cookistador
    Super User
    6 months ago

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

    )

  • Harish85's avatar
    Harish85
    Helper III
    2 months ago

    HI ,

    I have requirement, there are two columns ,part_des,part_fct , in one column it shows sold and ship to , but I want to show two different columns for sold to and ship to and it should show all columns , Is it possible to write a formula for that.