Conditional column to create new date column

[Anonymous]

Hi Community..!!

I want to create conditonal column as shown in the below pic but it should be in date format.

I have t2 month column , i need to create t1 month column as shown in the below pic.

Could anyone please help me out to reach the solution.

Thanks in advance..!!

[Anonymous · Accepted solution]

Hi Community..!!

I got the output by myself,

Here is the solution.

Previous Qtr = FORMAT(ENDOFQUARTER(PREVIOUSQUARTER(Result_tp1[MONTH-1])),"mmm yy")

[qqqqqwwwweeerrr]

Hi @Anonymous 

You can do this by creating column using this measure: 

previousdate = PREVIOUSMONTH(financials[Date])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[Anonymous]

Hi @qqqqqwwwweeerrr 
It will give previous month , mine requirement is different.

[qqqqqwwwweeerrr]

Hi @Anonymous 

My bad misunderstood the question. But can you please define the logic on what bases month should be tagged to some other month.

Regards