Forum Discussion
Need help in DAX
Name Skills Mahesh Power BI, Cognos, Tableau Saravan Tableau, Cognos Raju Power BI, MSBI Nagesh MSBI, Tableau Ravi Tableau, Power BI Requi...
Hey Anonymous ,
here you will find a pbix that contains a solution that does rely on data modeling instead of using DAX: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EZ1UYqubNL5OrQP-VIdgBEsBF93buB8kEzbOZhVW35sslA?e=Zj62yj
I created a second table using Power Query that looks like this:
Then I creatd a Many-To-Many relationship between both tables like so:
This data model allows to create the visuals you mentioned:
Hopefully this provides what you are looking for.
Regards,
Tom
v-eachen-msft
Community Support
Community SupportHi Anonymous ,
You could use split the "Skills" column and unpivot new columns in the query editor.
Then use "trim" to remove blank value.
Here is the result.
Here is my test file for your reference.