Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a table with a bunch of measures, with currently two dimensions, week of year and day of week.
My measures are either for that day of the current year or that day two years back.
Now, I would like to add two more columns, one with the current year date and one with the previous year date.
Does anyone know of a way to do this?
If I just add det date, the number of rows becomes double as of course due to the current year date and previous year being different. Still I would like to keep them on the same row.
Adding a picture of what it looks like now:
Any idea is greatly appreciated! Thanks!
Hi
This example APP may help you in the approach
Note that this APP example is'nt my production : i stored it from the forum as it was one of my requierment
(thanks to the original creator)
Hope it helps