Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have 15 columns. I want to create a custom column that checks if all 15 columns are not NULL to output either Complete or Incomplete
My logic is something like:
=
Solved! Go to Solution.
Hi @Anonymous,
with the function ISBLANK you can check if there is any value.
BLNK = VAR AnyBlank = ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] ) || ISBLANK ( TestTable[Column3] ) VAR Result = IF ( AnyBlank; "Incomplete"; "Complete" ) RETURN Result
Can you post some sample data?
Nick, I attached the sample table and sample formula i'm using
Hi @Anonymous,
please check the 3rd message of this thread if it is the solution you expect. We published our post in the same time and maybe it was overseen.
Logically that looks perfect but a followup question is where would I input that logic?
I created a custom column and then I get this Custom Column prompt which I'll attach below. Within this prompt, I get errors trying similar logic as you posed to I'm guessing that I'm not entering the information in the right area?
Hi @Anonymous ,
in PowerBI in tab Modeling click on New Column. And then insert the DAX code I've sent you.
Ah there we go. Thank you and I accepted the solution
Great to hear about that
Hi @Anonymous,
with the function ISBLANK you can check if there is any value.
BLNK = VAR AnyBlank = ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] ) || ISBLANK ( TestTable[Column3] ) VAR Result = IF ( AnyBlank; "Incomplete"; "Complete" ) RETURN Result
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!