Period that had biggest spike

[Mahmed1]

Hey

What Dax formula can i have that shows me the period with biggest spike in a visual?

Say i have a chart that shows me the months sale % by day

i want to be able to look at the % each and if it has increased day on day, get that start and period before it drops back but get the max period in that month 

i hope this makes sense

I dont have an example file to share but i can put a random file together just shows % sales by date

thank you

[Mahmed1]

Thank you for getting back to me...i will give that a go when i have access to open the file but looking at the picture it looks like it is what im after

i would then need to get a text combined measure so i can use in a title to say that the longest period where we had daily consecutive increase was from 10/05 to 15/05 increasing from 1.30% to 4.55% (increase of 3.25%)

will this work even if i didnt select a month so it gives me the longest period in the whole year or the filtered context?

thank you once again

really appreciate this

[Jihwan_Kim]

Hi,

Thank you for your feedback.

If possible, please share how your desired outcome of the visualization looks like when not selecting month-year from the slicer and shows the chart from 1-1-2022 to 12-31-2022.

Thank you.

[Mahmed1]

Spoiler

Hi

I had a look at your attachment and it looks like it gives the longest period per month if i select no months which is fine and i can use this for a different visual to show longest period per month

I guess what i would also need is to have the ability to see the longest period in the whole year and also have the title to show the start and end period/date of that longest period

Thank you once again

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below, and I hope the below can provide some ideas on how to create a solution for your data model. All measures are in the pbix file.