Forum Discussion

Usha_pk's avatar
Usha_pk
Icon for Helper II rankHelper II
2 years ago

How 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 
Need Help
Show and Tell
Tips and Tricks
AnalyticPulse's avatar
AnalyticPulse
Icon for Solution Sage rankSolution Sage
2 years ago

there would be confusion if you create a data column just by week and year, to get accurate date you need the day of the week and a month.

Learn Power BI free:

https://analyticpulse.blogspot.com

Learn Power BI free

Powerbi Visualisation

 

 

kpost's avatar
kpost
Icon for Solution Sage rankSolution Sage
2 years ago

I agree 100%. That's why I asked what he or she means, specifically, by "week", also what the expected result is.

 

If for example he or she wants the last day of that week, and [week] is, let's say, a 0-indexed weeknum value essentially equal to FLOOR(DIVIDE(julian date, 7), 1) etc.

 

Then [YEAR] 2024 and [WEEK] 0 could mean January 7,2024.

 

I'm hoping for some more clarity and sample data from Usha_pk