Forum Discussion

espinozan's avatar
espinozan
Helper I
9 years ago

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...
Need Help
Show and Tell
Tutorial Requests
  • espinozan's avatar
    espinozan
    Helper I
    9 years ago

    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?

     

    • cs_skit's avatar
      cs_skit
      Resolver IV
      9 years ago

      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.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi espinozan,

      Have you resolved your issue? If you have, please mark the right reply as answer. If you have not, could you please share more details or your sample table, and list the expected result for further analysis?

      Best Regards,
      Angelia