Forum Discussion
Sedos101
Helper I
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...
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
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