Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm trying to do a command but I can't work out how to get it to recognise 0 as a number rather than a blank, the issue I have is I have both blanks and 0's in my column, this is my command:
Solved! Go to Solution.
In the first clause , remove the '= BLANK()' and put isblank before the column name (with brackets round the column)
Use ISBLANK(column) rather than '= BLANK'
Sorry how do I work that into my command I already have? Thank you
In the first clause , remove the '= BLANK()' and put isblank before the column name (with brackets round the column)
Perfect thank you for your help 😊
.. by the way, although the code works, nested IFs like that are a nasty way to accomplish it. SWITCH is a much more readable way to go - like this:
Day Groups = SWITCH(
TRUE(),
ISBLANK( 'Claims Full + Complaints'[Days from Claim to Complaint] ), "No Complaint",
'Claims Full + Complaints'[Days from Claim to Complaint] = 0, "Within 15 days",
'Claims Full + Complaints'[Days from Claim to Complaint] < 16, "Within 15 days",
'Claims Full + Complaints'[Days from Claim to Complaint] < 31, "Within 30 days",
'Claims Full + Complaints'[Days from Claim to Complaint] < 61, "Within 60 days",
"Over 60 days"
)
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |