Peaks and Troughs

[Sedos101]

Hi Everyone

if I have a set of data in a column and I want to be able to flag the peaks and troughs how would I go about writing that in power query?

I basically have the conditions I want to use that would flag a peak, for example if it went above a certain value and then dropped below that value that would be one peak...

Thanks in advance

[Anonymous · Accepted solution]

Hi @Sedos101 ,

Could you please provide some sample data(exclude sensitive data) and special example to illustrate your expected result? If you want to get the column base on some conditions in Power Query, you can refer the following links to get it.

Conditionals

if 2 > 1 then 2 else 1          // 2
if 1 = 1 then "yes" else "no"   // "yes"

Power Query if Statements

Mastering IF Statements in Power Query – Including Nested IF-Statements

Best Regards