Forum Discussion

Mansso's avatar
Mansso
Regular Visitor
6 years ago
Solved

Convert measures to columns

Hi...i have some trouble with PBI.Can anybody help me? I need convert measures to columns..how i can do it with 
Show and Tell
  • Mansso's avatar
    Mansso
    6 years ago

    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?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Mansso，

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

 

Best Regards

Rena

Mansso's avatar
Mansso
Regular Visitor
6 years ago

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'[ТипПоказателяСреднее]= "Факт")
))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Mansso
      Regular Visitor
      6 years ago

      Want this

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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