How to pull a balance date and master data date

Hi bweiland,
Thank you for reaching out to the Microsoft fabric community forum. 

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

Dax Measure for Latest Master Data date:

Latest MasterData Date =

VAR SelectedDate = MAX(Balance[BalanceDate])

VAR CurrentAcct = SELECTEDVALUE(Balance[AccountNumber])

RETURN

CALCULATE (

    MAX(MasterData[MasterDate]),

    FILTER (

        MasterData,

        MasterData[AccountNumber] = CurrentAcct &&

        MasterData[MasterDate] <= SelectedDate

    )

)

Dax Measure for Latest Risk Rating:

Latest Risk Rating =

VAR SelectedDate = MAX(Balance[BalanceDate])

VAR CurrentAcct = SELECTEDVALUE(Balance[AccountNumber])

VAR LatestDate =

    CALCULATE (

        MAX(MasterData[MasterDate]),

        FILTER (

            MasterData,

            MasterData[AccountNumber] = CurrentAcct &&

            MasterData[MasterDate] <= SelectedDate

        )

    )

RETURN

CALCULATE (

    MAX(MasterData[RiskRating]),

    FILTER (

        MasterData,

        MasterData[AccountNumber] = CurrentAcct &&

        MasterData[MasterDate] = LatestDate

    )

)

Relationship between both tables:

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.