Pick speciifc dates from a date time column.

[YanGerzon]

Hi,

Say I have a model with a dimension that contains date and time information.

It can contain multiple values per day with different time data.

I need to pick from this column only the values that are the last day of the month(of whatever months there are in the column) and out of those only one value per day that has the most late time.
So if I have:
2022-04-29 05:32:02
2022-04-30 07:45:02
2022-04-30 09:45:02
I need to pick only 2022-04-30 09:45:02, since its the last day of the month and has the latest time

Thanks in advance.

[Sowmiya_C · Accepted solution]

Hi 101ger,

If my understanding is right then please find the below steps, Hope this works for you!

To get the Last date value we can achieve this by calculation.

Example: Here I have changed the Last date value as highlighted.

In story create an Aggregation calculation and select the operation as LAST

Output:

Please let me know if it works.

Thanks,

Sowiya

[YanGerzon · Accepted solution]

Yes,
Thank you.