topic Re: Stuck in MoM% change due to Monthyear slicer effects in DAX Commands and Tips

Stuck in MoM% change due to Monthyear slicer effects

AkashShetty — Mon, 09 Jun 2025 07:39:07 GMT

I am unable to view my YoY% and MoM% in the matrix with monthyear slicer(showing 0 values), the values are working fine with year slicer but i need it to work for each month as well. Please help with the same

YoY % Growth (Brand) =

VAR PYsales = CALCULATE(

SUM('Non F&B'[Sales]),

SAMEPERIODLASTYEAR('Non F&B'[Date].[Date])

)

VAR CYsales = SUM('Non F&B'[Sales])

RETURN

(IFERROR((CYsales-PYsales)/PYsales,BLANK()))

This is the syntax i am using for YoY change and i am using quick measure for MoM change
Please suggest some solutions, thanks in advance

Re: Stuck in MoM% change due to Monthyear slicer effects

bhanu_gautam — Mon, 09 Jun 2025 08:54:52 GMT

AkashShetty , Try using

DAX
YoY % Growth (Brand) =
VAR CurrentMonthYear = MAX('Non F&B'[Date])
VAR PreviousYearMonth = EDATE(CurrentMonthYear, -12)
VAR PYsales = CALCULATE(
SUM('Non F&B'[Sales]),
'Non F&B'[Date] = PreviousYearMonth
)
VAR CYsales = SUM('Non F&B'[Sales])
RETURN
IFERROR((CYsales - PYsales) / PYsales, BLANK())

And

DAX
MoM % Growth (Brand) =
VAR CurrentMonth = MAX('Non F&B'[Date])
VAR PreviousMonth = EDATE(CurrentMonth, -1)
VAR PMsales = CALCULATE(
SUM('Non F&B'[Sales]),
'Non F&B'[Date] = PreviousMonth
)
VAR CMsales = SUM('Non F&B'[Sales])
RETURN
IFERROR((CMsales - PMsales) / PMsales, BLANK())

Re: Stuck in MoM% change due to Monthyear slicer effects

AkashShetty — Mon, 09 Jun 2025 09:27:06 GMT

Thank you, but still not working

Re: Stuck in MoM% change due to Monthyear slicer effects

Poojara_D12 — Mon, 09 Jun 2025 12:41:54 GMT

Hi AkashShetty

The reason your YoY% and MoM% measures show zero values when using a MonthYear slicer is that time intelligence functions like SAMEPERIODLASTYEAR and DATEADD require a continuous date column to work correctly, rather than a text or formatted MonthYear field. If your slicer is based on a formatted MonthYear string (like "Jan 2025"), Power BI cannot properly interpret the date sequence, causing these calculations to return blank or zero. To fix this, you should use a dedicated Date table marked as a Date Table in Power BI, which contains a continuous date column. Then, instead of filtering by the MonthYear text field, use the actual Date column from this Date table in your slicer, configured to show months. Adjust your YoY and MoM measures to reference this Date table’s Date column in their time intelligence functions. This approach ensures the calculations respect the proper date sequence, allowing your YoY% and MoM% to display correctly at monthly granularity.

YoY % Growth (Brand) = VAR CYSales = CALCULATE(SUM('Non F&B'[Sales])) VAR PYSales = CALCULATE( SUM('Non F&B'[Sales]), SAMEPERIODLASTYEAR('DateTable'[Date]) -- use your date table ) RETURN DIVIDE(CYSales - PYSales, PYSales)

MoM % Growth = VAR CYSales = SUM('Non F&B'[Sales]) VAR PmSales = CALCULATE( SUM('Non F&B'[Sales]), DATEADD('DateTable'[Date], -1, MONTH) ) RETURN DIVIDE(CYSales - PmSales, PmSales)

Re: Stuck in MoM% change due to Monthyear slicer effects

Anonymous — Tue, 10 Jun 2025 06:59:56 GMT

Hi AkashShetty,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are trying to calculate Year-over-Year (YoY%) and Month-over-Month (MoM%) growth metrics for sales in a Power BI matrix visual. As Poojara_D12 and bhanu_gautam already responded to your query, kindly go through their responses and check if your issue can be resolved.

I would also take a moment to thank Poojara_D12 and bhanu_gautam, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

Re: Stuck in MoM% change due to Monthyear slicer effects

Anonymous — Mon, 16 Jun 2025 05:10:31 GMT

Hi AkashShetty,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If so, it would be really helpful for the community if you could mark the answer that helped you the most. If you're still looking for guidance, feel free to give us an update, we’re here for you!

Re: Stuck in MoM% change due to Monthyear slicer effects

AkashShetty — Mon, 16 Jun 2025 05:14:36 GMT

Hi,
I couldn't find the solution I was looking for, as a workaorund I am using both year and month slicers for accuracy which is long but works well. Thank you for all the help

Re: Stuck in MoM% change due to Monthyear slicer effects

Anonymous — Fri, 20 Jun 2025 06:21:34 GMT

Hi AkashShetty,

Appreciate you coming back and sharing the workaround. Using both Year and Month slicers can be a functional stopgap, especially when deadlines are tight or you just need something to work reliably.

That said, if you do revisit this later, I’d really recommend reviewing the setup of your Date table and how it interacts with your slicers. The key is making sure your slicer is operating on an actual continuous date column that’s what really unlocks the full power of those time intelligence functions like SAMEPERIODLASTYEAR and DATEADD.

If you'd like, I can take a look at your model or walk you through adjusting the slicer and date setup it’s usually a one-time fix that saves a lot of effort long-term.

Best Regards,
Hammad.

Re: Stuck in MoM% change due to Monthyear slicer effects

Anonymous — Mon, 23 Jun 2025 06:25:55 GMT

Hi AkashShetty,
I just wanted to follow up on your thread. If the issue is resolved, it would be great if you could mark the solution so other community members facing similar issues can benefit too.
If not, don’t hesitate to reach out, we’re happy to keep working with you on this.

Best Regards,

Hammad.

Re: Stuck in MoM% change due to Monthyear slicer effects

Anonymous — Thu, 26 Jun 2025 05:56:29 GMT

Hi AkashShetty,
We noticed there hasn’t been any recent activity on this thread. If your issue is resolved, marking the correct reply as a solution would be a big help to other community members.
If you still need support, just reply here and we’ll pick it up from where we left off.

Best Regards,

Hammad.