Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

Power 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) ...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    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's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
1 year ago

Hi again! I missed one thing - the relationship between the tables. I've updated the PBIX file to reproduce the same error

https://drive.google.com/file/d/1hRrtOCUvIX_uVUj96yBAE0ws2H0IjE9O/view?usp=drive_link

 

I created measure_field2 using the code you sent me and I'm using the Power BI functionalities I need (Single Date picker and Top n 1 ordered by date), but the code you provided isn't returning the expected results. The relationship must remain as it is currently configured, which is why I cannot implement it differently. I've tried modifying it, but doing so breaks my report.

Could you provide additional guidance considering this table relationship structure?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    If you insist on that relationship staying intact then i will not be able to help you because tht relationship should not exist in the first place.