Forum Discussion
Need help DAX & Matrix
- 2 years ago
Hi,
here the link with the pbix
https://we.tl/t-vMdkToWg1E
You need to create a FACT table with the answers and a DIMENSION table with the user.
Then you have to connect with the relationship ONE to MANY.
Study what is a DIMENSION (the unique value: examples client, supllier, employes etc...)
and a FACT your data (examples invoice, calls, events etc..).u
To create the fact table you need to use Power Query in the transform data.
Create one table for every type of answer: Finance, Health, Emotions and then APPEND it in a new one the only one table that you import.To create the DIMENSION table you need to do the distinct value of your users.
IF RESOLVER YOUR PROBLEM PLEASE MARK IT AS A SOLUTION.
Regards,
Luca D'Elicio
I can't download it.
Please use https://wetransfer.com/
it's free.
Thank you