Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
tosuns
New Member

Date format - week.year

Hello,
I have to make a report in which dates must filtered on 16 last weeks. But the format of my dates is:
WeekNumber.Year : 01.2019, for the first week of 2019.

This column format is text and I cannot transform it on date table and also cannot filter on 16 last weeks.

Need your helps !
Thanks in advance
1 REPLY 1
judspud
Solution Supplier
Solution Supplier

Hi @tosuns 

 

You could add extra columns to the data table which splits it up into week and year using the left and right functions.

 

You can then use these values to filter by the last 16 weeks etc.

 

Hope this helps

 

Thanks,

George

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.