Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
No. of RSO Sent | Ageing - JO IN to RSO (days) |
4 | NO DATA |
4 | 6 |
2 | 1 |
2 | 2 |
2 | 2 |
1 | 3 |
1 | 3 |
1 | NO DATA |
I tried to create a measure that meets the following conditions: 3 RSO Sent Within 3 Working Days
So I used the following formula:
Please advise on the correct formula. Thanks a lot.
Sya
Solved! Go to Solution.
Hi @sya
You can create a calculated column to get you the output you're after:
Column =
SWITCH (
TRUE () ,
'Table'[Ageing - JO IN to RSO (days)] = "NO DATA" , BLANK() ,
VALUE ( 'Table'[No. of RSO Sent] ) >= 3 && VALUE ( 'Table'[Ageing - JO IN to RSO (days)] ) <= 3 , "Yes" ,
"No" )
Attached is a PBIX file to assist.
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @sya
Slightly modify your measure to the following:
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi Theo,
I tried the formula that u shared but it results in the following:
And the formula doesn't suggest columns that are already in the table, but only suggested my other created measures to be in the formula.
Sya
Hi @sya
You can create a calculated column to get you the output you're after:
Column =
SWITCH (
TRUE () ,
'Table'[Ageing - JO IN to RSO (days)] = "NO DATA" , BLANK() ,
VALUE ( 'Table'[No. of RSO Sent] ) >= 3 && VALUE ( 'Table'[Ageing - JO IN to RSO (days)] ) <= 3 , "Yes" ,
"No" )
Attached is a PBIX file to assist.
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
It's working! Thanks a lot, Theo. You rock! 🙂
Nothing at all @sya! A pleasure.
All the best with you BI journey mate!
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |