issue on month over month variation metric when using day filter

ladislaocsulak — Fri, 05 May 2023 17:39:18 GMT

Hello,

I am having the following problem that I cannot solve.

I made a chart with bars and lines where the lines show the metric sales MoM that displays the month-over-month variation. Additionally, with a calendar table, I am using a slicer that filters by day to compare sales within a certain range of days.

Everything works perfectly, except for the following specific case that I cannot solve.

In the table I am uploading, the last recorded day is 5/5/23. If I filter to see the information for days 1 to 4, the metrics work perfectly. But if I filter to see the information for days greater than or equal to the last day recoded, it stops working (for example 1 to 5 or 1 to 8). Does anyone know what I can modify to make it work consistently?

I am uploading the Power BI file with the example and the metrics created:

https://drive.google.com/drive/folders/1SIBxFXl1CB3n0gnH2GM6CJe9044dHk_M?usp=share_link

Thank you very much in advance.

Re: issue on month over month variation metric when using day filter

ThxAlot — Sat, 06 May 2023 07:13:09 GMT

Follow this pattern

topic issue on month over month variation metric when using day filter in DAX Commands and Tips

issue on month over month variation metric when using day filter

Re: issue on month over month variation metric when using day filter