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.
Hi all
I need to convert this DAX measure
Name | Level | Status |
Extract 2D plans | APS | High |
Extract 2D plans | EXE | Medium |
Extract 2D plans | LIV | Low |
Other Function | APS | Medium |
Other Function | EXE | Low |
Other Function | LIV | High |
And what I want is as follows:
Name | APS | EXE | LIV |
Extract 2D plans | High | Medium | Low |
Other Function | Medium | Low | High |
I suggest pivoting the table in Power Query.
However, the link the pbix file (above) shows two solutions. (Power Query way and DAX).
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim thanks for your answer.
Actually I need something generic considering the distinct Levels. For example, if I have only APS and EXE, then I don't need the LIV column. However, if I have 4 distincts Levels, then I'll need 4 columns to be added. Would it be possible to generalize in DAX? In Power query I can't use because I have many calculated columns in DAX that are not available in Power query.
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |