Forum Discussion

MageVortex's avatar
MageVortex
Icon for Helper I rankHelper I
4 years ago

Rolling Average quick measure breaks with Card Visualization

Hello, I have a quick measure to calculate a rolling average. It was working last month, but now in January, the Card visual shows a 'Blank' value instead of the actual value. When I place the measu...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi MageVortex 

 

Is your date table formulated using DAX?

 

If so, how did you formulated the first and last date of the Date table? You may need to update the end date of your date table (e.g. change the end date to be in the future).

 

MageVortex's avatar
MageVortex
Icon for Helper I rankHelper I
4 years ago

I went through the process of creating a Power BI DAX based

Calendar = CALENDAR(today()-900,today())
Once I set up the model connections, and set it up, I get teh same 'Blank' result.
  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    MageVortex 

     

    As good as Power BI is, setting up a calendar in that manner unfortunately will not work very effectively unless relationships and relevance have been established.  Instead of working on Dates, Calendars, etc., can you tell me what is the outcome that you are trying to achieve?  By this, I mean, what is "roll6SupTo no ReOrg" trying to calculate?

    • MageVortex's avatar
      MageVortex
      Icon for Helper I rankHelper I
      4 years ago

      The total/overall average of the 6 month rolling average of the Supervisor turnover excluding a certain segment of those supervisors.  As the original image shows, it still calculates it, but now it won't display in the KPI box.
      This is what it looks like pre 2022

       

      This is it now

      Again, if I change the date range to be before 1/1/2022, it works, but once I include 2022, it no longer generates that total.