Forum Discussion
Convert DAX expression into a table
Hi all I need to convert this DAX measure Measure = CALCULATE( MAX('Table 1'[Status]), FILTER('Table 1','Table 1'[Level]=MAX('Table 1'[Level])) ) into a new table. I tried wit...
I suggest pivoting the table in Power Query.
However, the link the pbix file (above) shows two solutions. (Power Query way and DAX).
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.