Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi.
I have created this extra "sort by column" and I would like to define the blanks in "Data[Løsnings_dage] as "0" and still has 0-1 defined as "1". How do I do that? I have tried to insert:
IF(ISBLANK(Data[Løsnings_dage]), 0 , Data[Løsnings_dage])
0,
Data[Løsnings_dage]
)
at the beginning of the equation but it does not work 😞
What am I doing wrong?
Best regards,
Lisa
Solved! Go to Solution.
You just have to put this in the beggining:
IF(
ISBLANK(Data[Løsnings_dage]),
"0" ,
... (the rest)
I will also suggest you to use SWITCH instead of so many nested IF's. It would look something like:
SWITCH(TRUE(),
ISBLANK(Data[Løsnings_dage]), "0",
Data[Løsnings_dage] <= 1, "1",
Data[Løsnings_dage] >= 2 && Data[Løsnings_dage] <= 5, "2",
....
)
You just have to put this in the beggining:
IF(
ISBLANK(Data[Løsnings_dage]),
"0" ,
... (the rest)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!