Forum Discussion

eraldo_DP's avatar
eraldo_DP
Frequent Visitor
6 years ago
Solved

How to calculate target by data?

Hi Everyone,   How i can calculate the target corresponding to the date and group?   https://1drv.ms/u/s!As-s3TNexQ8TipkPATGyYTW6Fbr-qA?e=gLg3Ev    
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Here is a measure expression that returns the Target for the Date and Group on that row of the table.

     

    GroupDate Target =
VAR __thisdate =
    SELECTEDVALUE ( Sales[Date] )
VAR __thisGroup =
    SELECTEDVALUE ( Sales[Group] )
RETURN
    CALCULATE (
        MAX ( Target[Target Conversation] ),
        ALL ( Target ),
        Target[StartDate] <= __thisdate,
        Target[EndDate] >= __thisdate,
        Target[Group] = __thisGroup
    )

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

  • eraldo_DP's avatar
    eraldo_DP
    6 years ago

    Perfect, thanks for this solution.

AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

You will have to explain more, not sure what you are trying to do.

  • eraldo_DP's avatar
    eraldo_DP
    Frequent Visitor
    6 years ago

    I need returne in columm "Target_Conversation" the target active for the period. Example, in table "Target" have the columm name "Group" and others columns with Start date and End date for the group.

     

    Then the "Group1" has 6% of Target with start 2020/04/01 and finish in 2020/04/05, i need return the value Target active for date for comparison the value realized and value projected.