Forum Discussion

Tob_P's avatar
Tob_P
Helper V
4 years ago
Solved

Relative Date using multiple dates

Hi there - just trying to see if this is possible or if anyone has done something similar.   I have a table that shows product sales and you can slice on those salespeople within in. However I want...
  • johnt75's avatar
    johnt75
    4 years ago

    Try storing the bonus start date in a variable

    Product target filtered sales =
SUMX (
    'TblTargets(2)',
    VAR bonusStartDate = 'TblTargets(2)'[Product bonus start date]
    RETURN
        CALCULATE (
            SUM ( 'Nav_Sales History MASTER'[Amount (LCY)] ),
            KEEPFILTERS ( 'Nav_Sales History MASTER'[Order date] >= bonusStartDate )
        )
)
johnt75's avatar
johnt75
Super User
4 years ago

Try storing the bonus start date in a variable

Product target filtered sales =
SUMX (
    'TblTargets(2)',
    VAR bonusStartDate = 'TblTargets(2)'[Product bonus start date]
    RETURN
        CALCULATE (
            SUM ( 'Nav_Sales History MASTER'[Amount (LCY)] ),
            KEEPFILTERS ( 'Nav_Sales History MASTER'[Order date] >= bonusStartDate )
        )
)
Tob_P's avatar
Tob_P
Helper V
4 years ago

johnt75 

 

Great stuff! Works a treat. Thanks for helping out!