Forum Discussion
Dax formula for early dates
Hi All, I have a data set that contain 3 columns (for the example)
Shipping ID, invoice number & invoice date, I want to create a calculeted column that will bring per each shipping ID the earliest date that assosiate with his invoices, pic below for the example, thx !
Anonymous
Download PBIX file with the example below
New Inv Date = VAR _id = [Shipping ID] RETURN CALCULATE(MINX('DataTable', 'DataTable'[Inv Date]), FILTER(('DataTable'), 'DataTable'[Shipping ID] = _id))Regards
Phil
1 Reply
- PhilipTreacy
Super User
Anonymous
Download PBIX file with the example below
New Inv Date = VAR _id = [Shipping ID] RETURN CALCULATE(MINX('DataTable', 'DataTable'[Inv Date]), FILTER(('DataTable'), 'DataTable'[Shipping ID] = _id))Regards
Phil