depth to found start date

[Anonymous]

Hello All,

I need your help to fund the start Date from the End Date and Depth so as you can see here :

So I need to calculate the datesbetween Start Date and End Date but I dont have End Date How can I do because I have Data table containing Date (End Date ) and I have Depth(profondeur) Table containing day number so in this exemple I need to calculate :

Date between (28/11/2020 - 3) and 28/11/2020

Thanks in advance for your Help 🙂

[v-kelly-msft]

Hi @Anonymous ,

You may use DATESBETWEEN function,see below reference:

https://docs.microsoft.com/en-us/dax/datesbetween-function-dax

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Syndicate_Admin · Accepted solution]

Thanks Kelly

DATESBETWEEN is not working well so I used the DATESINPERIOD and it was OK