Forum Discussion

Sai_Alkesh's avatar
Sai_Alkesh
Helper II
4 years ago
Solved

undefined

Hi, Need help with the following: I have 2 tables: Table Currency Identifier field LCurrency FCurrency FX Rate Type     Period yyyymm         EUr           GBp           0.8545    AVRS   20214 ...
Calculated columns
DAX
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Sai_Alkesh 

    try this calculated column

     

    ColumnTest = 
VAR _currency =
    CALCULATE (
        MAX ( 'Currency'[FXRate] ),
        FILTER (
            ALL ( 'Currency' ),
            'Currency'[LCurrency] = EARLIER ( 'Sales'[Currency] )
        )
    )
RETURN
    'Sales'[Sales] * DIVIDE ( 1, _currency )

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Sai_Alkesh 

    In this scenario, you can modify the red part. 

    -

    EARLIER: EARLIER function (DAX) - DAX | Microsoft Docs

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Sai_Alkesh's avatar
Sai_Alkesh
Helper II
4 years ago

v-xiaotang : as a follow up, if i want to put more conditions, how do i do that ? 

The above works, if there is only condition to filter. But if i want to filter more than one column, how will do it?

Appreciate your help !!

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Sai_Alkesh 

In this scenario, you can modify the red part. 

-

EARLIER: EARLIER function (DAX) - DAX | Microsoft Docs

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.