Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional column to create new date column

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..!!

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Community..!!

    I got the output by myself,

    Here is the solution.

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

     

4 Replies

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • qqqqqwwwweeerrr's avatar
        qqqqqwwwweeerrr
        Solution Sage
        2 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Community..!!

    I got the output by myself,

    Here is the solution.

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