Forum Discussion

PBI_37's avatar
PBI_37
Icon for Helper I rankHelper I
1 year ago
Solved

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 : ...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    1 year ago

    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]

  • Anonymous's avatar
    Anonymous
    1 year ago

    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 Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

OktayPamuk80's avatar
OktayPamuk80
Icon for Responsive Resident rankResponsive Resident
1 year ago

Hi,

Did you try to connect your calendar.year with your target.year? In your visual, you should then use calendar.date, too.

 

Regards,
Oktay

 

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.