Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello Guys,
I have used this If statement to find loading status, but instead of considering only blanks it is also considering zeros and giving false values. How to solve this
Loading status =If(('AC'[loading end date]=BLANK()&&'AC'[loading start date]=BLANK()),"Not Loaded", "Loaded")
I'd appreciate suggestions on how to deal with this problem.
Thanks,
Manikanta
Solved! Go to Solution.
Trying using the ISBLANK() function (https://docs.microsoft.com/de-de/dax/isblank-function-dax)
For example:
IF( ISBLANK('AC'[loading end date]) && ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")
or
IF( ISBLANK('AC'[loading end date]) || ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")
Trying using the ISBLANK() function (https://docs.microsoft.com/de-de/dax/isblank-function-dax)
For example:
IF( ISBLANK('AC'[loading end date]) && ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")
or
IF( ISBLANK('AC'[loading end date]) || ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")
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!