Calculating accros multiple columns and visualizing with a timeline

Hi PowerBI_User16 ,

bhanu_gautam logic is sound and provides a strong foundation. I have a couple of suggestions in line with Power BI best practices.

1. Instead of comparing month names (e.g., January <= February), it's more effective to create a separate Month Number column (with values 1 to 12). This approach ensures your calculations are accurate and your visuals are sorted correctly.
2. For improved performance and flexibility, consider using a DAX measure rather than a calculated column, especially when your calculation must adjust based on context (for instance, filtering by year, account, etc.). Measures are evaluated at query time, offering more dynamic behaviour for your visuals.

Helpful Reference: Learn DAX basics in Power BI Desktop - Power BI | Microsoft Learn

Thnaky you for your inputs bhanu_gautam .

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.