cancel
Showing results for
Did you mean:
Highlighted
Member

## HOW can I get Similar Result of Tableau in POWER BI with Calculation Please

Hi Experts,

Hello to Everyone. I am a new POWER BI user, but Heavy user of Tableau. I have the following Three Columns of Data in my Table.

 ID Status Changed Date 2303 A 11/7/2017 14:00 2303 A 11/7/2017 14:01 2303 A 11/7/2017 14:01 2303 A 11/7/2017 14:02 4657 B 11/6/2017 14:53 4657 B 11/6/2017 14:53 4657 B 11/8/2017 10:51 4988 C 11/8/2017 11:18 4988 C 11/9/2017 11:05 4988 C 11/9/2017 11:08 4988 C 11/9/2017 11:10

Using the Following LOD Expression in Tableau

{FIXED [ID],[Status]:MAX([Changed Date])}

Which Simply Says that for a Particular ID and Status Find out the Maximum Date from Many Changed Dates Available for that Combination of ID and Status.

So When I Use the above Formula, I get MAX Date in additional Column

 ID Status Changed Date MAX Date 2303 A 11/7/2017 14:00 11/7/2017 14:02 2303 A 11/7/2017 14:01 11/7/2017 14:02 2303 A 11/7/2017 14:01 11/7/2017 14:02 2303 A 11/7/2017 14:02 11/7/2017 14:02 4657 B 11/6/2017 14:53 11/8/2017 10:51 4657 B 11/6/2017 14:53 11/8/2017 10:51 4657 B 11/8/2017 10:51 11/8/2017 10:51 4988 C 11/8/2017 11:18 11/9/2017 11:10 4988 C 11/9/2017 11:05 11/9/2017 11:10 4988 C 11/9/2017 11:08 11/9/2017 11:10 4988 C 11/9/2017 11:10 11/9/2017 11:10

So for all the Dates in 3rd Column , I get Only 3 Dates for a particular ID and its Corresponding Status which are the MAXIMUM dates I Need

How Can I Get the 4th Column  (MAX DATE) in POWER BI with some Formula. Can somebody provide the FORMULA?

Thanks a Lot

Deepak

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: HOW can I get Similar Result of Tableau in POWER BI with Calculation Please

@drrai66

Hi, you can usea a calculated column:

```MaxDate =
CALCULATE (
MAX ( Table1[Changed Date] ),
FILTER (
Table1,
Table1[ID] = EARLIER ( Table1[ID] )
&& Table1[Status] = EARLIER ( Table1[Status] )
)
)```

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

2 REPLIES 2
Super User

## Re: HOW can I get Similar Result of Tableau in POWER BI with Calculation Please

@drrai66

Hi, you can usea a calculated column:

```MaxDate =
CALCULATE (
MAX ( Table1[Changed Date] ),
FILTER (
Table1,
Table1[ID] = EARLIER ( Table1[ID] )
&& Table1[Status] = EARLIER ( Table1[Status] )
)
)```

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

Member

## Re: HOW can I get Similar Result of Tableau in POWER BI with Calculation Please

Victor, Thanks Man!!, This is what I was looking for.

Thanks

Deepak