Forum Discussion
julsr
Continued Contributor
Continued ContributorPower BI DAX: Calendar Table Integration Breaking Existing Measure Logic
Hi PowerBI Community, I have an interesting DAX challenge involving the integration of a new Calendar table into an existing model. Here's my scenario: I have three tables: A fact table (TABLE1) ...
Hi,
Revise the measure to
measure_column = CALCULATE(SUM(Budget[AMOUNT_FIELD]),DATESBETWEEN('Calendar'[Date],MAX('Calendar'[Date])+1,MAXX(ALL('Calendar'),'Calendar'[Date])))Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
I do not know what you want to calculate. In the attached file, i have set up the tables, relationships and slicers properly. Build your measures now.
Hope this helps.
- julsr
Thanks! Attached is the PBIX file and the measure. The expected result is a measure that once the filter from the calendar table is active returns the sum of the budget from the budget amount field where budget Date > CAlendar date. (i.e. if February is selected in the calendar slicer, the result must be the sum of the budgets from March and April, 384,000)
https://drive.google.com/file/d/1hRrtOCUvIX_uVUj96yBAE0ws2H0IjE9O/view?usp=sharing
Thanks
- Ashish_Mathur
Hi,
Revise the measure to
measure_column = CALCULATE(SUM(Budget[AMOUNT_FIELD]),DATESBETWEEN('Calendar'[Date],MAX('Calendar'[Date])+1,MAXX(ALL('Calendar'),'Calendar'[Date])))Hope this helps.
- julsr
Thanks! It's working now.
