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.
I have the following.
Computer Col1 Col2 Col3 ........many more columns
A r q null
B null p r
I need the following result where the ColN data is ordered alphbetically by the values. ie col1=p, col2=q, col3=r etc....
Computer Col1 Col2 Col3 ........many more columns
A null q r
B p null r
Any suggestions please.
The solution will likely involve list and record functions (e.g., Record.ToList, List.Sort). Can you post some more example data and explain the logic for how null values should be handled?
Pat
Please see pbix : https://drive.google.com/file/d/1ol1xxWHH0Q6ay76DSrv4abOgzc60ZjYL/view?usp=sharing
Source Data & Required Outcome are provided
I have made 1 attempt in Source Data (2)
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |