Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Experts,
Is it possible to change the following with DAX expressions instead of using power query ?
Hi @koorosh
Original data :
You can create a calculated table like this :
Table 2 = SUMMARIZECOLUMNS('Table'[ID],"A1", CALCULATE ( MAX ( 'Table'[Values] ), 'Table'[Attributes] = "A1" ),
"A2", CALCULATE ( MAX ( 'Table'[Values] ), 'Table'[Attributes] = "A2" ),
"A3", CALCULATE ( MAX ( 'Table'[Values] ), 'Table'[Attributes] = "A3" ))
Then add a table visual to display column [A1][ A2][ A3] .
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ailsa,
Thanks, but how you did make ID in the Table? Especially when the data become large.
Best Regards
Koorrosh
Hi @koorosh ,
It is not impossible to do pivoting in DAX, but very often there are better solutions depending on what you would like to achieve. Is this a particular visual you are after?
Here is an example / discussion about a similar issue that might give you some additional inspiration 🙂
Solved: Pivot or Transpose Table using DAX rather than Pow... - Microsoft Power BI Community
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |