Convert measures to columns

[Mansso]

Hi...i have some trouble with PBI.Can anybody help me?

I need convert measures to columns..how i can do it with 

[Greg_Deckler]

Usually that means taking out the aggregations in the measure. Would need to see the formula to be certain.

[Mansso]

Here

https://dropmefiles.com/tey7E

[Mansso]

So..anybody?

[v-yiruan-msft]

Hi @Mansso，

Could you please provide the formula of your measure and explain what is used for? Thank you.

Best Regards

Rena

[Mansso]

Sry..this

Рентабельность поля Отклонение =

(CALCULATE('dat _1cModel_Finance'[ПланФактВаловыйДоходПоляБезБонусов_Finance];'dat _1cModel_Finance'[ТипПоказателяСреднее]= "План")

-

(CALCULATE('dat _1cModel_Finance'[ПланФактВаловыйДоходПоляБезБонусов_Finance];'dat _1cModel_Finance'[ТипПоказателяСреднее]= "Факт")

))

/

(CALCULATE('dat _1cModel_Finance'[ПланФактОказаноУслуг_f];'dat _1cModel_Finance'[ТипПоказателяСреднее]= "План")

-

(CALCULATE('dat _1cModel_Finance'[ПланФактОказаноУслуг_f];'dat _1cModel_Finance'[ТипПоказателяСреднее]= "Факт")

))

[v-yiruan-msft]

Hi @Mansso

Thanks for providing formula. Do you want to turn these measure values that were originally displayed on the rows with displaying in columns ? Or just replace the measure with a calculated column ? If it is the former , you need to provide some sample data and screenshots of the your expected result. It would be better if your PBIX files(exclude sensitive data) could be provided.

Best Regards

Rena

[Mansso]

Want this

Do you want to turn these measure values that were originally displayed on the rows with displaying in columns ?

[v-yiruan-msft]

Hi @Mansso，

Due to we are not clear about your table structure and ultimately what visual you want to present your data, could you please provide some sample data and screenshots of the your expected result. It would be better if your PBIX file (exclude sensitive data) could be provided.

Best Regards

Rena

[Mansso · Accepted solution]

Ok..i done this..

I need 1 more help pls)

I have date column Month.

I need no make new column.wich means Month Before (is TSQL it is DATEADD (datepart , number , date )

)

How i can make this on PBI?

[v-yiruan-msft]

Hi @Mansso ,

There is also DATEADD function in DAX, please check if you can use this function to return the value you want .

Best Regards

Rena

[Mansso]

Thx..i'll try it

[v-yiruan-msft]

Hi @Mansso ,

If your problem has been resolved, could you please mark it as Answered? Thank you.

Best Regards

Rena

[v-yiruan-msft]

Hi @Mansso,

Whether the function DATEADD works well for your scenario?

Best Regards

Rena

[Greg_Deckler]

@Mansso That just showed me an image, I need the formula for your measure.

[PietroFarias]

Depends. How is this measures?