Date format - week.year

[tosuns]

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

[judspud]

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