Forum Discussion
Rolling Calculation
Hello everyone, I currently have a rolling trend in my report and it works great. However, I'm trying to get my visuals to show one year worth of data using this trend but for some reason it curr...
Hi cs_skit,
Thank you for your reply, I've created the table in the Query Editor. But im not sure how this could be implemented into my data. Do you mind explaining further? I'm a begginer with Power BI so all of this is kind of new to me.
What do you mean I could add overall Quarter numbers by a range selection?
Yes in the calendar table you add an index for the quarters. Then you need a measure like "This Quarter" and just select by Quarter between this quarter and quarter - 3.
You could even do more complex stuff like join your calendar table with a quarter table and a fiscal year table.