Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I'm trying to set up a report for my company and am facing difficulties calculating correct YTD and YTD-1 measures due to the fact that the date format in the data source is odd.
As seen in the picture above, the data source shows data for week 52 of 2022, which should be impossible. This is most likely due to week 52 2021 going into 2022, thus being identified as 2022. I've attemped to create a custom date column (due to the fact that my data doesn't include any specific dates, only week number & year), by combining year and week number into a column, then using this formula to create dates:
Solved! Go to Solution.
HI @Bobbys,
I'd like to suggest you create a calendar table with the custom 'year week' field to link to the current table fields. Then you can use the related date field values for YTD calculations.
Regards,
Xiaoxin Sheng
HI @Bobbys,
I'd like to suggest you create a calendar table with the custom 'year week' field to link to the current table fields. Then you can use the related date field values for YTD calculations.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |