Forum Discussion
Dimitris_Kats
Helper V
Helper VReversed rolling total
Hello dear members. I have a problem and I need your help. I have a measure that calculates a percentage for January, February, March, April and May. May 2023 is my max month year. I want for J...
Hi.
I have found a solution. It was easier than I thought.
I filtered me date table and the logic behind my calculations is as follows:
time[date]>= January && time[date] <= max month - current month+1 😊😊
Dangar332
Resident Rockstar
Resident RockstarHi, Dimitris_Kats
please provide proper data format in table form
Dimitris_KatsHelper V
Helper VHi. Thank you very much for your reply.
First of all I have a date table linked to my fact table.
My matrix looks like this:
Month Year % desired measure
January 23 8% 20%
February 23 6% 19%
March 23 3% 17%
April 23 2% 14%
May 23 1% 8%
Thank you very much in advance