DIFFERENCE BETWEEN MULTIPLE DATES

Question

HiI 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&nbsp;I'm looking for a dax formula to calculate ''DIFFERENCE''&nbsp;FILTER : CarsSELL DATEDIFFERENCE13/01/2023&nbsp;14/01/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 118/01/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 426/01/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 804/02/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 907/02/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3…&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;…&nbsp;FILTER : TrucksSELL DATEDIFFERENCE14/01/2023&nbsp;18/01/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 419/01/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 121/01/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 204/02/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1407/02/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3…&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;…

grazitti_sapna · Answer

Hey, you can try using DIFFERENCE =VAR CurrentProduct = SELECTEDVALUE('Product'[Product Name])VAR CurrentDate = SELECTEDVALUE('Sales'[Sell Date])RETURNCALCULATE(MIN('Sales'[Sell Date]) - CurrentDate,FILTER(ALL('Sales'),'Sales'[Product Name] = CurrentProduct &amp;&amp;'Sales'[Sell Date] &lt; CurrentDate))Thank you. Hope this will help

anonymous · Answer

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

grazitti_sapna · Answer

Hey,You can try usingDIFFERENCE =VAR CurrentProduct = SELECTEDVALUE('Product'[Product Name])VAR CurrentDate = SELECTEDVALUE('Sales'[Sell Date])RETURNDATEDIFF(&nbsp; &nbsp; MINX(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Sales',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Sales'[Product Name] = CurrentProduct &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Sales'[Sell Date] &lt; CurrentDate&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 'Sales'[Sell Date]&nbsp; &nbsp; ),&nbsp; &nbsp; CurrentDate,&nbsp; &nbsp; DAY)Thnak youHope this will help.&nbsp;

Forum Discussion

DIFFERENCE BETWEEN MULTIPLE DATES

3 Replies

Related content

Date difference with multiple criteria

How to avoid people creating multiple times the same table in different workspaces

Different schema into different destination

Multiple PDFs Different Tables

MULTIPLE CARD

SELL DATE	DIFFERENCE
13/01/2023
14/01/2023	1
18/01/2023	4
26/01/2023	8
04/02/2023	9
07/02/2023	3
…	…