HELP: How to use SAMEPERIODLASTYEAR with condition

[thiagolb]

Hey guys,

I'm having issues when I try to compare relative dates with a condition.

I want compare relative days of the week, for example: 01-01-2018 was a monday, and 01-01-2018 was a sunday, so these two dates are no comparables to my demand. So I'd like to compare 01-01-2018 with 01-02-2017 to compare mondays with mondays, tuesday wit tuesday and so on.

Anyone know how to solve this problem?

[v-jiascu-msft · Accepted solution]

Hi @thiagolb,

The week is a complicated thing. The weekday of 2016-01-01 is Friday. So I would suggest you create a new column of [Week Number Day]. The week number of a year is static and you can adjust it easily. The weekday is also static. Finally, those different days can be cited by the [Week Number Day].

WeekNumDay =
WEEKNUM ( [Date], 2 ) & "-"
    & WEEKDAY ( [Date], 2 )

Best Regards,

Dale

[thiagolb]

Thank you Dale!

I did this and worked, the thing is, I wnated to show the dates as a subtitle in X axis but I think this is not possible.

Anyway, the dashboard is now working and showing the datas correctly.

Best regards.