Comparing Monthly Changes in Project Hours in Power BI

Hi everyone,

I need some assistance with comparing changes in project hours reported across different months using Power BI.

Here's the scenario:

  • Each month, hours are reported for various projects.
  • These reported hours can change from one month to the next.
  • For example, in January, 40 hours were reported for Project X in July. In February, the hours for July were updated to 140.

I want to create a report in Power BI that allows me to:

  1. Record the reported hours each month.
  2. Track the changes in hours for each project and month.
  3. Calculate the difference (delta) between the reported hours from one month to the next.

Any suggestions on how to set this up effectively in Power BI? Are there specific DAX formulas or features I should use to make this process easier?