Forum Discussion

Viper1451's avatar
Viper1451
Frequent Visitor
6 years ago
Solved

Budgetprices with different Hierarchy

Hi all,   I just started with Power BI and did some basic courses to create measures and dashboard and I'm helping a friend now to create a dashboard. He's working in the concrete business and havi...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Viper1451 ,

     

    You need a date condition, add a filter in it.

    Budget Revenue =
SUMX (
    fOrder,
    fOrder[QtyOrdered] * RELATED ( dProductTable[Weight in kg] )
        * (
            CALCULATE (
                MAX ( fBudget[Budget Price per kg] ),
                FILTER ( fBudget, YEAR ( fBudget[Date] ) = YEAR ( fOrder[OrderDate] ) )
            )
        )
)

    Here is the result.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Viper1451 ,

 

You need a date condition, add a filter in it.

Budget Revenue =
SUMX (
    fOrder,
    fOrder[QtyOrdered] * RELATED ( dProductTable[Weight in kg] )
        * (
            CALCULATE (
                MAX ( fBudget[Budget Price per kg] ),
                FILTER ( fBudget, YEAR ( fBudget[Date] ) = YEAR ( fOrder[OrderDate] ) )
            )
        )
)

Here is the result.

 

  • Viper1451's avatar
    Viper1451
    Frequent Visitor
    6 years ago

    v-eachen-msft : thanks so much for your help and the solution!