Forum Discussion
srk_powerbi
Helper II
Helper IIcreate 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 da...
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.
V-lianl-msft
Community Support
Community SupportHi 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.