Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to create a Pivot table on calculated column - Please help me..It is urgent

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.

 

1 ACCEPTED SOLUTION

@Anonymous ,

 

You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.

https://community.powerbi.com/t5/Desktop/Column-Header-names-should-contain-current-month-dynamically/td-p/289909

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
autodafe
Resolver I
Resolver I

Why don't you use a Matrix ?

Anonymous
Not applicable

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.

https://community.powerbi.com/t5/Desktop/Column-Header-names-should-contain-current-month-dynamically/td-p/289909

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

https://community.powerbi.com/t5/Desktop/Column-Header-names-should-contain-current-month-dynamically/td-p/289909


 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.