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 split the Scope Values by rows as I need to keep a "Number of Contracts" measure. I split the values into Columns. I now want to analyse these 17 different Scope Values that are scattered around 8 columns. How can I do that?
Please find below an example of my data.
| Scope Values .1 | Scope Values .2 | Scope Values .3 | Scope Values .4 | Scope Values .5 | Scope Values .6 | Scope Values .7 |
| 1 | 2 | 6 | null | null | null | null |
| null | null | null | null | null | null | null |
| 17 | 12 | 3 | 5 | 6 | 9 | 15 |
| 15 | 1 | 3 | 13 | null | null | null |
Thank you in advance for your help.
2 Replies
- lbendlin
Super User
As I cannot split the Scope Values by rows as I need to keep a "Number of Contracts" measure. I split the values into ColumnsI would challenge that. Splitting into columns is not sustainable especially if the number of contracts fluctuates. Please show the original data source structure.
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
