How to get last date of posting date field date...

[ashrat001]

Hi Experts,

I have different dates in the column/filed of Posting date. I want to get last date of the date or month in the Posting date field/column and save it in the new column of my table.  Thanks!

[Pragati11]

Hi @ashrat001 ,

Just create the DAX calculation shown in the below screesnhot:

The left column DATE is the column in my dataset. I have sorted it in ascending order so that it shows the maximum date at the top row in my dataset.

Then I created a new column on the right which shows the maximum date stored in every row with same value in the dataset.

Just replcae tablename and column name with your in the above DAX expression.

Thanks,

Pragati