Comparision of monthly revenue with montly goals

[Rudi]

Hello,

I want to compare your monthly revenue und profit with our monthly goals which are determined in a lookup-table.

How can I get access to this table and read the goal for the current month to compare the same month (Oct. with Oct)?

The data and goal of the current month should be displayed in a card or KPI.

I need help to build the DAX-Formula.

Here is a sample file: https://1drv.ms/u/s!AlFrCtjKAQwSgydwd1TuFUsGpPYP

For further information please download the file.

Thanks in Advance!

Best Regards

Rudi

[Rudi]

Sample file is provided.

Please find the link in my 1st post.

Thanks

Rudi

[Anonymous · Accepted solution]

See attachment. Is this what you want

https://ufile.io/cqm38

[Anonymous]

Sample file please