POWER BI DAX MEASURE

Hi Julier ,

I have reproduce your scenario in Power BI Desktop and validate the requirement.

To achieve the expected result, I implemented the following approach:

• Created a proper Date table and used it for time intelligence
• Built a complete Site × Date dataset to ensure all dates are present
• Used SUM with DATESMTD for cumulative calculations
• Calculated Remaining Capacity as:
  Monthly Capacity – Used Capacity MTD

With this setup:

• Used Capacity increases day by day
• Remaining Capacity decreases across the month
• Demand can be compared correctly against capacity

I’m getting the expected output based on your requirement.

For your reference, I’ve attached the sample .pbix file with the complete working solution.

Thank You.