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 send you the request to download the file from the drive.
Thank you
- haniizz2 years agoHelper II
Hi Luca, sorry something with that file
but here is another link pbix file
thank you for your intension to support- lucadelicio2 years agoImpactful Individual
I can't download it.
Please use https://wetransfer.com/
it's free.
Thank you