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 guys,
The below table shows the programs that each ID (Column Name: CR Number) has been served in:
I want to create a calculated column using DAX indicates if the ID was served in only one program or more than one. For example: first row shows the applicant was served in three diffrent programs while last one was only served in one program.
thank you,
regards,
Solved! Go to Solution.
Hi @salafoo
Probably it would be best to unpivot the data to have that info in a column instead of on several ones. If you want to keep this structure:
New column =
VAR count_ = 1 * ( Table1[Served in TWS] = "Yes" ) + 1 * ( Table1[Served in BCS] = "Yes" ) // and so on with the other columns...
RETURN
IF ( count_ = 1, "Served in 1", "Served in more than 1" )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @salafoo
Probably it would be best to unpivot the data to have that info in a column instead of on several ones. If you want to keep this structure:
New column =
VAR count_ = 1 * ( Table1[Served in TWS] = "Yes" ) + 1 * ( Table1[Served in BCS] = "Yes" ) // and so on with the other columns...
RETURN
IF ( count_ = 1, "Served in 1", "Served in more than 1" )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Thank you so much. It works perfectly as I wanted.
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |