How to copy a column of dates but that the dates are those recorded before the date

[Anonymous]

Very good, I am trying to create a column PREVIOUS DATES which I must take out of a swing DATES, the dates have different difference of days since they are updated every 2.3 or up to 6 days apart so a -1 does not help me.

If you see the image of my felling the dates of Previous Date and Date are the same.

I'd like to know if there's a way to leave the dates like this:

Any DAX commands that can help me?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You want measure or column?

I'll provide you both formula.

Measure = CALCULATE(MAX('Table'[date]),FILTER(ALLSELECTED('Table'),'Table'[date]<SELECTEDVALUE('Table'[date])))

Column = CALCULATE(MAX('Table'[date]),FILTER('Table','Table'[date]<EARLIER('Table'[date])))

 

Best Regards,

Jay

[Anonymous]

Columnans works perfect. Thanks a lot.

[Pragati11]

Hi @Anonymous ,

Try following steps:

1. Create an INDEX column in your data by going to Query Editor under ADD COLUMNS section.

2. You will have data something like this:

3. Then create the following measure and you will get expected result.

Prev Date Value = CALCULATE(MAX(ClothingSales[Date]), FILTER(ClothingSales, ClothingSales[Index] = EARLIER(ClothingSales[Index]) - 1))

Modify the DAX expression above with your tablename and column name.

Thanks,

Pragati

[Anonymous]

Grax, but I dealt with this and the query editor didn't recognize me from the table I created.

Thank you from all the maeras.