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 [...
  • 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")

    )

Harish85's avatar
Harish85
Helper III
3 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.