Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DIFFERENCE BETWEEN MULTIPLE DATES

Hi I have a table with different sales dates X product , i want to put them on a visualisation matrice to have the difference between each sales date filtered by product name as showed below   I'm...
Need Help
grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
3 years ago

Hey, you can try using

DIFFERENCE =

VAR CurrentProduct = SELECTEDVALUE('Product'[Product Name])

VAR CurrentDate = SELECTEDVALUE('Sales'[Sell Date])

RETURN

CALCULATE(

MIN('Sales'[Sell Date]) - CurrentDate,

FILTER(

ALL('Sales'),

'Sales'[Product Name] = CurrentProduct &&

'Sales'[Sell Date] < CurrentDate

)

)

Thank you. Hope this will help

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Thanks but this is giving me a date as result and not a number

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    3 years ago
    Hey,
    You can try using
    DIFFERENCE =
    VAR CurrentProduct = SELECTEDVALUE('Product'[Product Name])
    VAR CurrentDate = SELECTEDVALUE('Sales'[Sell Date])
    RETURN
    DATEDIFF(
        MINX(
            FILTER(
                'Sales',
                'Sales'[Product Name] = CurrentProduct &&
                'Sales'[Sell Date] < CurrentDate
            ),
            'Sales'[Sell Date]
        ),
        CurrentDate,
        DAY
    )
    Thnak you
    Hope this will help.