Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Convert Date descriptions to date

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.

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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