Looking for the last month máximum.

[ale_nilo84]

Hello, good day

I have a chart with three fields

Date : im date format

Time : in hour format

Plate: In text format

I also have a vperiodonummax variable , which calculates the last month.

I need to look for the máximum time and its associated plate with the group of plates of the last month.

[sunny_talwar · Accepted solution]

May be like this:

Dimension

Date

Expression

Max({<Month = {"$(=vperiodonummax)"}>}Time)

FirstSortedValue({<Month = {"$(=vperiodonummax)"}>}Plate, -Time)

If that doesn't work, would you be able to provide a sample to look at?

[ale_nilo84]

Thanks works with FirstSortedValue !! However it appears a null value when two values ​​are equal field time . How I can fix it ?

[#4]

If you have only 3 dimentions you have to do some more simple for example

Load

Plate,

Max(Date)

From Nomber_Table

Group by Plate;

After you can Join This Table for example with your Fact Table with the column Plate

Best Regards!!!

[sunny_talwar]

Which one do you want to pick? May be try this

FirstSortedValue(DISTINCT {<Month = {"$(=vperiodonummax)"}>}Plate, -Time)