The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a measure that was working previously, but is no longer working after a data refresh. The following function:
Requests Completed by Month = COUNTX(FILTER('Production Approval Workflow', 'Production Approval Workflow'[Date_Prod_Val_Review].[MonthNo]),[Title])
Is producing this error:
Column reference to 'Date_Prod_Val_Review' in table 'Production Approval Workflow' cannot be used with a variation 'MonthNo' because it does not have any.
The column is a defined as a date datatype. Are the null dates the issue? What I am trying to do is get a monthly count of completed items [Title].
Any thoughts or suggestions?
Hi @comish4lif
You could try to change the formula to:
Requests Completed by Month = COUNTX(FILTER('Production Approval Workflow', MONTH('Production Approval Workflow'[Date_Prod_Val_Review]),[Title])
So in stead of: Table[date.column].[MonthNo] --> MONTH(Table[date.column])
Hi @comish4lif,
First the error has nothing to do with Null dates.
And I can repro your issue. If I disable the Time intelligence (Auto Date/Time) option in File/Options and Settings/Options/Data Load. The error shows up.
Thereby, please verify your Time intelligence setting.
Thanks,
Xi Jin.
Xi Jin,
Thanks for the response - but the Time Intelligence was selected (it had the checkmark).
I unchecked Time Intelligance and a bunch of visualizations and measures that were working then became broken.
Any other suggestions?
Hi @comish4lif,
One possibility. Have you created any relationships on this table 'Production Approval Workflow'? Relationship can affect date hierarchy. Please verify this.
Thanks,
Xi Jin.
Do I have relationships on that table? Only about 9.
What type of relationship should I be looking at as the source of my problem?
Hi @comish4lif,
Ok. It's hard to say. Could you please share us your pbix file with OneDrive if possible? So that I can know your actual situation and make some proper tests.
If you can't share us the file. I would suggest you check all the relationships one by one. Start from date columns.
Thanks.
Xi Jin.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |