Forum Discussion
Helper ICalculated column to evaluate values across columns
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,
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
2 Replies
- AlB
Community Champion
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
salafooThank you so much. It works perfectly as I wanted.