March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have a table and I need to show the data depending upon one column, I am trying to write a measure that will show the number of work items if that colu
Solved! Go to Solution.
Hi @e77948 ,
In Power Query, it's like this:
if somethingIsTrue
then doThis
else if somethingElseIsTrue
then doThisThingInstead
else doThisThing
In DAX, it's like this:
IF(
somethingIsTrue,
doThis,
doThisThingInstead
)
Pete
Proud to be a Datanaut!
Ah, ok, my bad. Text functions don't skip blanks.
Try this one:
if [Tags] = null then "Primary"
else if Text.Contains([Tags], "Secondary") then "Secondary"
else "Primary"
Pete
Proud to be a Datanaut!
Hi @e77948 ,
Sorry for that the information you have provided is not making the problem clear to me.
Can you please share more details (your tables, your problems, the expected output) to help us clarify your scenario? Or try methods provided by @BA_Pete .
Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
if Text.Contains([Tags], "Secondary") then "Secondary" else "Primary" or if isBlank([Tags], "Primary")
Hi @e77948 ,
'isBlank' isn't an M language function, it's a DAX function.
If you can describe the behaviour that you're trying to achieve, I can write the correct M code syntax for you.
Pete
Proud to be a Datanaut!
I want the custom column to say "Primary" if the column "Tags", does not contain the word "Secondary", or if the "Tags" column is blank, and I want the new column to say "Secondary" if the "Tags" column, contains the word "Secondary".
Cool. Try this in a new custom column:
if Text.Contains([Tags], "Secondary") then "Secondary" else "Primary"
Based on your requirement, we don't need to specify anyhting for a blank [Tags] value, as we just pass anything that doesn't contain "Secondary" as a "Primary" output.
Pete
Proud to be a Datanaut!
I get errors for the 25 rows that are blank when I use that query,
Ah, ok, my bad. Text functions don't skip blanks.
Try this one:
if [Tags] = null then "Primary"
else if Text.Contains([Tags], "Secondary") then "Secondary"
else "Primary"
Pete
Proud to be a Datanaut!
Hi @e77948 ,
In Power Query, it's like this:
if somethingIsTrue
then doThis
else if somethingElseIsTrue
then doThisThingInstead
else doThisThing
In DAX, it's like this:
IF(
somethingIsTrue,
doThis,
doThisThingInstead
)
Pete
Proud to be a Datanaut!
Please refer to - How to Get your Question Answered Quickly - https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
20 | |
12 | |
10 | |
10 | |
7 |
User | Count |
---|---|
43 | |
26 | |
16 | |
16 | |
11 |