Forum Discussion

DJims86's avatar
DJims86
Frequent Visitor
1 year ago
Solved

Issue with Referencing Date Column in Calculated Column for Date Comparison

Hi everyone,   I’m working on a Power BI report and encountering an issue when trying to create a calculated column that categorizes data based on a specific cutoff date. My goal is to label rows a...
Need Help
  • DJims86's avatar
    DJims86
    Frequent Visitor
    1 year ago

    Thank you very much for your help with this. I did have one more question:

     

    When I click on 2025, for example, to view that data, I can see a gap between February and March that I will need to fill. Is there a way to close this gap in the visualization?

     

     

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

      yes, but you need to indicate in which direction - extend actuals to the right, or extend projected to the left?

      • DJims86's avatar
        DJims86
        Frequent Visitor
        1 year ago

        I would need the Actual (blue) to move to the right to meet Projected at March.