Convert Date descriptions to date

[Anonymous]

Hello,

I am having an issue on how to convert Date description to Date field. For example I have the following Date descriptions

Current quarter (CQ-0) and I want to convert to the actual date then I have the previous quarter (Q-1) and I want to calculate the previous querter, then Q-2 and so on . The same applies to current month (cm-0) , previous month (M-1) and so on and the same for days CD-0 until CD-365.

I want to convert these to be dynamic i.e. current month is different today than what it will be next month.

[amitchandak · Accepted solution]

@Anonymous , split by delimiter in power Query

and the from date subtract that

= Date.AddDays(DateTime.Date(DateTime.LocalNow()), -1* [Day])

On top of date create quarter and year