Forum Discussion
Helper IPeaks and Troughs
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
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.
if 2 > 1 then 2 else 1 // 2 if 1 = 1 then "yes" else "no" // "yes"Mastering IF Statements in Power Query – Including Nested IF-Statements
Best Regards
1 Reply
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.
if 2 > 1 then 2 else 1 // 2 if 1 = 1 then "yes" else "no" // "yes"Mastering IF Statements in Power Query – Including Nested IF-Statements
Best Regards