Forum Discussion
Reporting on separated values in one cell without splitting or with column split
Hi All, I have got a table containing contracts. These contracts have some numerical values that describe the contract scope. I had all these Scope Values in one single Column. As I cannot sp...
HI Anonymous,
The current dax formulas are not suitable to analyze records across multiple fields, perhaps you can try to do unpivot columns on these fields then you can use attribute and value fields to write dynamic conditions on attributes to analyze between these field values.
Unpivot columns - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng