Forum Discussion
Data modeling - Actual vs Target
Hi everyone,
I would like to compare Actual vs Target.
I have a problem with my Data Model.
Actual table :
Target table (the target is fixed for the year) :
Data model :
It does not work :
Desired outpout :
Here the link of PBI file :
https://drive.google.com/file/d/1WLSOCFoAXzECpaJK7VSTCKw_WLvsy2_J/view?usp=sharing
Thank you for your help
Try this:
For Actual Value replace with this measure: ActValue = SUM(Actual[Actual Value])
For target, use this: Target = IF( [ActValue] = BLANK(), BLANK(), MAX(Target[Target Value]))Variance : Variance = [ActValue] - [Target]
Hi PBI_37 ,
I have made changes in your source file, please check the result below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Try this:
For Actual Value replace with this measure: ActValue = SUM(Actual[Actual Value])
For target, use this: Target = IF( [ActValue] = BLANK(), BLANK(), MAX(Target[Target Value]))Variance : Variance = [ActValue] - [Target]
Hi,
Did you try to connect your calendar.year with your target.year? In your visual, you should then use calendar.date, too.
Regards,
OktayDid I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Hi PBI_37 ,
I have made changes in your source file, please check the result below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-tianyich-msft and Tutu_in_YYC
