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?

Mansso's avatar
Mansso
Regular Visitor
6 years ago

So..anybody?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

  • 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