topic How to compare all-time monthly values and output percentage changes ? in DAX Commands and Tips

How to compare all-time monthly values and output percentage changes ?

PowerBiGuru2 — Mon, 17 Oct 2022 17:41:45 GMT

Hello Community,

I am experiencing difficulty creating a DAX Command that compares my monthly averages and percentage changes. I need to see all-time average rather than the average for the month. I will include the information below. I need to display the % change in a table with the following columns:

Product Identification, (All time - 2022-9), (All time - 2022-10), and % change.

I do not own the live dataset.

Any help would be greatly appreciated. I will provide images below.

Thank you!

Best,

Re: How to compare all-time monthly values and output percentage changes ?

v-zhangti — Tue, 18 Oct 2022 02:40:20 GMT

Hi, PowerBiGuru2

I failed to complete the understanding. What do you expect the output to be? Is it possible to expand your sample data and expected output in Excel?

Best Regards,

Community Support Team _Charlotte

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

Re: How to compare all-time monthly values and output percentage changes ?

PowerBiGuru2 — Tue, 18 Oct 2022 13:26:56 GMT

Hello v-zhangti,

Thank you for your response. I have attempted building Excel pivot tables to accomodate my needs. Unfortunately, that was not ideal as my "... code" would not match the two separate date ranges.

I have provided an image below to further identify my objective:

Due to keeping the anonymity, "... Code" serves as my replacement identifier (highlighted in black). In yellow are the numbers I need to compare in order to output a % change. The logic would be as follows:

"A12... Code" All time - September = 4.71 All time - October = 4.71 4.71-4.71 = 0 0/4.71 = 0.00%

The 0.00% should be the new column output.

Thank you!