Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

datediff between first and lastdate

Hi,   I need a measure to calculate the time between the first and last delivery date per Purchase order   The table is such as:   Receivedorderline Purchase order Receivedate 1 1 1-1...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    hi, Use a measure 

     

    DaysDiff = DATEDIFF(Min(Table1[Receivedate]),MAX(Table1[Receivedate]),DAY)

     

    Now Put in a visual the PO and this Measure.

     

     

     

EvertonPessoa's avatar
EvertonPessoa
Helper I
9 years ago

Hi Anonymous,

An alternative is to create a new table using dax Summarize: If you do not know: To create a new table go to the tab: modeling>
New Table

 

Dax to create the table:

 

Table2 = SUMMARIZE(Table1; 
		   Table1[Purchase order]; 
		   "MinDate"; MIN(Table1[Receivedate]);
		   "MaxDate";MAX(Table1[Receivedate]); 
	           "Total"; MAX(Table1[Receivedate]) - MIN(Table1[Receivedate])
		   )
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

 

Is it really necessary to create a new table? After this i think my Datamodel isn't 'nice' anymore

Because i merged before receivedorders and receivedorderlines to one new table (as a fact table)

 

When i make 2 seperate tables i can also make a calculated column in receivedorders like:

Column  = CALCULATE((MAX(receivedorderlines[Receivedate])-MIN(receivedorderlines[Receivedate])*1);

FILTER(receivedorderlines;receivedorderlines[order]=receivedorder[order]))