I have a table with the following columns
CaseNumber Elect Gas Sewer Trash Water
Elect, Gas, Sewer, Trash, and Water; they all have 0 as the default value. Each CaseNumber has these 5 fields.
12345 S T A 0 S
12346 S T A S S
I want a formula that returns a column (UtilityStatus) if the following conditions are met:
If(Elect,Gas, Sewer, Trash & Water are all diff from 0, Complete, Partial)
Therefore, following examples above, this is the result I shoul get.
CaseNumber Elect Gas Sewer Trash Water UtilityStatus
12345 S T A 0 S Partial
12346 S T A S S Complete
Go to Solution.
Hi @roxanacastro ,
How about this:
Here the DAX for the calculated coumn =
Table[Elect] = "0", "Partial",
Table[Gas] = "0", "Partial",
Table[Sewer] = "0", "Partial",
Table[Trash] = "0", "Partial",
Table[Water] = "0", "Partial",
My first question was, what you wanna return if all columns are 0, but that might not even happen in your data. So, I was just stubbornly following your requirement 🙂
Let me know if this helps 🙂
Proud to be a Super User!
View solution in original post
This worked perfectly.
Answering your question: if all my columns are 0, I want "Partial", which of course happens with your formula. Thank you!
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.