Forum Discussion

Shahabh786's avatar
Shahabh786
Frequent Visitor
2 years ago
Solved

Help Needed: Finding Minimum Growth Value in Power BI

Hello, I need assistance with finding the minimum growth value for each region, regardless of the month or year. I'm currently calculating the growth compared to the same period last year using the ...
Need Help
  • Shahabh786's avatar
    Shahabh786
    2 years ago

    I was able to finally achive this using below workaround.

    ADDCOLUMNS (
                FILTER (
                    SUMMARIZE ( 'Sales', 'Calendar'[MonthYear] ),
                    [MonthYear] <> _CurrentMonthYear
                ),
                "@SPLM", [Monthly Growth %]
            )
Shahabh786's avatar
Shahabh786
Frequent Visitor
2 years ago

I was able to finally achive this using below workaround.

ADDCOLUMNS (
                FILTER (
                    SUMMARIZE ( 'Sales', 'Calendar'[MonthYear] ),
                    [MonthYear] <> _CurrentMonthYear
                ),
                "@SPLM", [Monthly Growth %]
            )