Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Unpivot Column with Different Calculation Applied

Hi there,   I am trying to unpivot data matrix using pwoer query but the data calculation is not only using summraize but also average since the value have different value format, iie. absolute num...
Calculations
unpivot
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Total Target (Switch) =
IF (
    CONTAINSSTRING ( MAX ( 'Table'[Indicator] ), "%" ),
    AVERAGEX ( VALUES ( 'Date'[YearMonth] ), [Total Target] ),
    SUMX ( VALUES ( 'Date'[YearMonth] ), [Total Target] )
)

    Same for total actual

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , I am assuming the first one is the source

 

How to Deal with Double Headers in Power BI | Free Power BI Tutorials: https://youtu.be/1e16oHv9kTk

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Amit, 

    Thanks for sharing your thought. However the steps is still not achieve what I need to perform different calculation type per-each category/indicator As you may see in the scond table.