Forum Discussion

srk_powerbi's avatar
srk_powerbi
Icon for Helper II rankHelper II
5 years ago
Solved

create a period column in data table

Hi,

I have a date table and want to add another column to find which Period ( WTD,MTD,QTD,YTD) it belongs. If i take 5/1/2021, it falls under three buckets MTD,QTD,YTD. I want to do that for each date..

DatePeriod
5/1/2021MTD
5/2/2021MTD
5/3/2021MTD
5/4/2021MTD

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi srk_powerbi ,

     

    Based on your description, you need to create 4 columns because the dates will be repeated over different periods.

    Or you can concatenate periods into a column.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi srk_powerbi ,

     

    Based on your description, you need to create 4 columns because the dates will be repeated over different periods.

    Or you can concatenate periods into a column.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.