Forum Discussion
Actual vs Target
Dear Community, I am currently modeling a report that needs me to prepare a graphic or a KPI card that would indicate actual values vs target values. Actual values are reported with individual d...
First create a date table and mark it as a date table. There's plenty of articles and videos on that if you're unsure how to.
Link the 'Date'[Date] to your orders table in a one-to-many relationship. Link 'Date'[Year] to your target table in a many-to-many relationship with a single direction so that 'Date' filters targets.
You can then use the 'Date'[Year] column as a slicer or filter to only show data for the chosen year.
You would need to create 3 measures like
Num Orders = COUNTROWS( 'Orders' )
Target Value = SUM( 'Targets'[Target] )
Performance against target = DIVIDE( [Num Orders], [Target Value] )Thank you very much
