In a PowerBi Gantt chart, I had added two formulas to calculate the previous month from this month and a different formula to calculate the next month from this month.
The relevant fields contain this figures:
Start: Date Completion (Date) / Prev Month (Measure) End: Date Completion (Date) / Next Month (Figure)
The goal was for the Gantt chart to show the following months: November December January
When using both formulas, the result says there is no data.
Result when using just the Prev Month measure: December 2023 to May 2024 Result when using just the Next Month measure: March 2022 to January 2024
The previous month description When entering both month calculations
Here is a link to the file. The goal is to show the previous month, the current month, and the next month. The most I have been able to get is this month and the next month.
https://drive.google.com/file/d/1GKj_f18zeOQtEIroiIP-kgFmtQXXPDkN/view?usp=sharing