Search code examples
powerbidaxdata-analysispowerbi-desktopmeasure

Total current month disappeared with the new year

Today it's 1/1/2024 and the total Current Month in my Power BI dashboard is not showing since today:

enter image description here

That measure is calculated this way:

This is how it's calculated:

Total Current Month = CALCULATE(
    'Costs Summary Table'[Sum of measures],
     FILTER(
        'Calendar',
        'Calendar'[Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1) &&
        'Calendar'[Date] <= TODAY() -2
    )
)

There are no filters applied.

Why passing from 2023 to 2024 broke my dashboard?

Solution

  • As Davide already mentioned, your current logic is: give me this month's value upto two days before today. So it will always return null for the first 2 (or 3 days) of each new month.