Based on filter selection need to show latest date based data

[Anonymous]

Hi All,

I have parameter called company name when the user selects on company name based on that i want to in visual latest as of date of Actual and budjet values.

Actual = CALCULATE(SUM('Table for graph'[Formatted Value]),'Table for graph'[version_name] = "Actual")

Budget = CALCULATE(SUM('Table for graph'[Formatted Value]),'Table for graph'[version_name] = "Budget")

when i select Company A i want to show Acutual and budget values based latest AsOfDate column same applicable when i select other company as well.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?