Forum Discussion
Helper IRolling Average quick measure breaks with Card Visualization
Helper IBecause I pulled the data in by month for those queries, and my dates table is by day. It's tied to it so it matches the 1/1/2021 in the month field to the 1/1/2021 dates table 'dateValue'.
I can change the date/time to date, but if I do it on one of the tables, it breaks my measures. Not entirely sure why without doing a lot more work.
I did some checking, and if I set my 'Dates' table to end and not update past 12/31/2021, then my 'Blank' measure works again. It's only once I let the Dates update to 1/1/2022.
- TheoC
Community Champion
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
The date table is a SQL data pull from a date table we maintain which includes a cornicopia of additional potential data points around each of those dates. For instance, markers for if 1/5/2022 is a weekend day or weekday, or if it is teh first monday of the month, first weekend day of the month, or has a holiday on it, etc etc.
As to changing the end date of the table to go into the future, I can't understand why that could be the issue as it worked perfectly fine not going into the future in 2021. When I change my date query to stop on 12-31-2021, the measure works perfectly fine, but when I then let it go into 2022, it immediately stops working and goes Blank. This didn't happen at any point last year when it was the beginning or middle of the month.I've been working on creating a DAX based calendar and creating a hierarchy, but having to manually create it is annoying as it automatically created the hierarchy for me with my sql query based dates table, and when I try to use this custom made DAX based calendar, instead of whoing all of the months going back historically, it only shows the last 6 months....sigh....each attempt creates 5 more questions to solve.
- MageVortex
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
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?
