cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

Month over Month Price Change (with last available price)

Hi everyone, I have a unit price table as follows:

I need to calculate month to month price movements (%).

I have 3 main product groups with a few subgroups.

Column sections present last year months.

The main issue for me is that some products weren't sell in 2 consecutive months.

Another possible problem could be that in one month could be a few sales of the same item.
That means I need average unit price on particular month.

I tried with various posted solutions but nothing have been seem working for me.

Thank you in advance for help!

14 REPLIES 14
Post Prodigy

It looks like it's gonna work!

One question though, how to hide infinity value in first month?

Community Support

Hi @pawelj795 ,

You could edit the DAX with an IF function.

```IF(a<>BLANK(),
('Table (2)'[value]-a)/a,BLANK())```

If this post helps, then please consider Accept it as the solution to help the other members find it.
Post Prodigy

Turns out, its not working properly.

Maybe because I have various values for same month?
I mean in same month, one product could be sold for different prices -> that's why I want to calculate average price in every month

Post Prodigy

Post Prodigy

up

Community Support

Hi @pawelj795 ,

You could use SUMMARIZECOLUMNS() function to create a table with average value per month( group by month ).

If this post helps, then please consider Accept it as the solution to help the other members find it.
Post Prodigy

Ok, I tried that solution but how modify your previous functions (rank & value%) to work with this new table?

I mean it's working only when I had one distinct value per month.
I cant really solve how to get deeper and have grouped values by group also, which mean I would have 3 values per every month.

Post Prodigy

Ok, I tried that solution but how modify your previous functions (rank & value%) to work with this new table?

I mean it's working only when I had one distinct value per month.
I cant really solve how to get deeper and have grouped values by group also, which mean I would have 3 values per every month.

Post Prodigy

up

Post Prodigy

up

Post Prodigy

up

Post Prodigy

up

Post Prodigy

Turns out, it's not working properly.

Maybe because I have various values for the same month

Community Support

Hi @pawelj795 ,

You could ignore blank value with functions.

Here is my test file for your reference.

If this post helps, then please consider Accept it as the solution to help the other members find it.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors