Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
I am trying to create a DAX table with 7 rows and 12 columns and each cells inside are previously created different measures.
Please let me know if this is possible and how can we acheive this. I am new to DAX and any help would be appreciated.
Many thanks,
Midhun
Hi @Anonymous
Please, visualize your input and desired output data 🙂
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @az38 ,
Thanks a lot for getting back to be.
I hope the below helps:
This is the Output I am looking for. Each rows are calculated from different data sets. Say, to calculate Starting value, I have a measure between two tables. Same for all the rows.
Currently I have created a visual similar to the below using KPI cards showing each measure. But this is causing Power Bi web service to load very slow.
I was wondering If I could manage to create a DAX table with each of the mesuare as cells exactly as shown in the below stucture may be it will help.
Hope this gives you an idea. Please let me know if you need any more information.
Thanks a lot,
Midhun
Well, @
I think the best option is to use Matrix visual.
Use Date hierarchy as columns and Measures as values
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @az38 ,
Thanks, let me try that, Cheers!
Also, then I may need to slipt this into two Matrix on for sales and one for profit.
Is it possible to call mesuares as cells in a DAX table?
Thank you for your time.
Many thanks,
Midhun
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |