Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have 2 calulated collumn in my Data model, and I want to create a seperate Pivot table in my data model with those 2 column , but as the calculated column is not visible at 'Edit Queries' window, I cannot select them to create Pivot table.
So I decide to create a Pivot table using Dax , So any idea how we can do that? Please share some code to do that.
Solved! Go to Solution.
@Anonymous ,
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
Why don't you use a Matrix ?
Hi,
I want to create a seperate table in my data model with 2 calculated columns, but not on the visual chart matrix. So please help me how can I do that with the help of DAX.
For this I have created a DAX like below , but I am getting error on this:
Table2 =
var Delivery = CROSSJOIN(ROW("Type","Time To Delivery"), VALUES(Data[Time_To_Delivery]))
var Sent = CROSSJOIN(ROW("Type","Time To Send"), VALUES(Data[Time_To_Send]))
return UNION(Delivery, Sent)
@Anonymous ,
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
How would i use for measures rather than caculated columns?
@v-chuncz-msft wrote:@Anonymous ,
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |