CODEWITHSUNDEEP
datepowerbimaxdax
brian rik
brian rik

Reputation: 25

Finding the max date between few date columns in each row - POWER BI

I assume my data looks like this (column names):

name (String)
age (Whole Number)
date1 (Date)
date2 (Date)
date3 (Date)
date4 (Date)
gender (String)

I would like to add a new column to the table that will contain the MAX date in each row between the dates (date1, date2, date3, date4).

example: Tami 16 1/2/2020 2/2/2020 4/2/2020 null female --> 4/2/2020 (new calculated column).

Can't find a way to make it in Power BI using DAX.

Upvotes: 2

Views: 4541

Answers (1)

W.B.
W.B.

Reputation: 5525

You need 3 nested MAX functions. MAX(YourTable[date1], MAX(YourTable[date2], MAX(YourTable[date3], YourTable[date4]))).

Upvotes: 2

Related Questions