Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Query for a calculated measure or column

Need the dax query for the below conditions in screen shot. There are two tables FKTA_F_ALTERED_MESSAGES and FKTA_F_ACTIONS with one to one relationship.

 

Need Help
Show and Tell
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if this measure could work:

    Measure =
IF (
    MAX ( 'FKTA_F_ALTERED_MESSAGES'[FLAG_LIVEHIST] ) = 1,
    MAX ( 'FKTA_F_ALTERED_MESSAGES'[CURRENT_DATE] )
        - CALCULATE (
            MAX ( 'FKTA_F_ACTIONS'[ACTION_DATETIME] ),
            'FKTA_F_ACTIONS'[FKCO_STATUS] = 17
        )
)

     

    In addition, please share us more details.

    Reference: How to Get Your Question Answered Quickly - Microsoft Power BI Community

     

     

    Best Regards,

    Icey

     

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

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    if there is a 1:1 relationship can you merge the tables?

     

    Please provide sample data in usable format (not as a picture) and show the expected outcome.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Please check if this measure could work:

    Measure =
IF (
    MAX ( 'FKTA_F_ALTERED_MESSAGES'[FLAG_LIVEHIST] ) = 1,
    MAX ( 'FKTA_F_ALTERED_MESSAGES'[CURRENT_DATE] )
        - CALCULATE (
            MAX ( 'FKTA_F_ACTIONS'[ACTION_DATETIME] ),
            'FKTA_F_ACTIONS'[FKCO_STATUS] = 17
        )
)

     

    In addition, please share us more details.

    Reference: How to Get Your Question Answered Quickly - Microsoft Power BI Community

     

     

    Best Regards,

    Icey

     

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