Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need to convert qlik expression to DAX

Hello Team, I need to convert the qlik Expression to dax. 2 table in power BI Table Fact Table combination ColorNumber field from Fact table RegrindColorNumber field from combination table _Re...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    Please try this:

    SUMX(
    FILTER(
        'combination table',
        LEFT( [RegrindColorNumber], 1 ) = LEFT( 'Fact table'[ColorNumber], 1 )
    ),
    _RegrindStartingInventory
)

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Please try this:

SUMX(
    FILTER(
        'combination table',
        LEFT( [RegrindColorNumber], 1 ) = LEFT( 'Fact table'[ColorNumber], 1 )
    ),
    _RegrindStartingInventory
)

 

Best Regards

Community Support Team _ chenwu zhu

 

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