Forum Discussion
Usha_pk
Helper II
2 years agoHow to create a Date column using Year and week combination
Hi team, Can you please help me how to create a date column using year and week in powerbi. Thank you! Ritaf1983 Greg_Deckler amitchandak Ashish_Mathur parry2k MFelix
Anonymous
2 years agoNot applicable
Hi all,
First of all, thank you all for your prompt responses.
Hi Usha_pk ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
Add a custom column.
Date.StartOfWeek(Date.AddWeeks(#date([Year], 1, 1), [Week]-1))
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.