Solved: How to calculate Sales Date dimension - Page 2

rohit_shoppertr · 12-12-2021 09:34 AM

I have one date dimension_group “transaction_date”(Year, month, month num...) and one column sales. I need to create three measures or columns which works dynamically

Sales of latest year and latest month(Dec 2021)
Sales of latest year and this month(Nov 2021)
Sales of last year and this month(Dec 2020)

Dawid

No it won’t. ISOWEEK is an ISO standard implementation when it comes to days of the week. Starting from Monday as 1 and ending with Sunday as 7.

If you want to “play with time” and create customised weeks then you would have to translate timeframes selected in Lokker, for example “Last 1 completed Week” to not be a simple calculation of difference of weeks, you would have to shift the days . It’s possible but also hacky - I needed to do it once when a reporting week (for one explore) was Friday - Thursday…

In short - it’s a nightmare 😄

View solution in original post