Forum Discussion
Post ProdigyShow available columns based on selection
Hi joshua1990 - I would suggest using Power Query to modify the data model to achieve this result in a matrix:
The key is create the following table which is combination of tables 2 and 3:
note the "N/A" are added using the SELECTVALUE function. This replaces blanks, but it would also replace Duplicates, so be careful with duplicated status.
Also make sure that tblArticles includes all the Articles.
Many thanks
Daryl
Hi joshua1990 - I would suggest using Power Query to modify the data model to achieve this result in a matrix:
The key is create the following table which is combination of tables 2 and 3:
note the "N/A" are added using the SELECTVALUE function. This replaces blanks, but it would also replace Duplicates, so be careful with duplicated status.
Also make sure that tblArticles includes all the Articles.
Many thanks
Daryl
joshua1990Anonymous : Thanks a lot! But why would you do that in Power Query instead of DAX? Since it is a really huge table, I would assume it would be better to calculate this in DAX?