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

[Anonymous]

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.

[autodafe]

Why don't you use a Matrix ?

[Anonymous]

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)

[v-chuncz-msft · 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

[Anonymous]

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

---