Forum Discussion
Matrix with additional columns
Hi vipett ,
Achieving your goal is possible, but it involves utilizing advanced DAX/PQ techniques. Essentially, you need to generate a table with a column storing the period, total, and additional columns. This task can be accomplished using either DAX or M. Subsequently, you create a measure to retrieve the desired value based on the specified period/total/extra columns. The structure of your table would resemble the following:
Please see attached sample pbix.
Hi vipett ,
Achieving your goal is possible, but it involves utilizing advanced DAX/PQ techniques. Essentially, you need to generate a table with a column storing the period, total, and additional columns. This task can be accomplished using either DAX or M. Subsequently, you create a measure to retrieve the desired value based on the specified period/total/extra columns. The structure of your table would resemble the following:
Please see attached sample pbix.
Thanks, did it virtually this way and that worked.
Created a new crossjoin with a new table with these additional ones and the summarized it all
