Forum Discussion
Solved
Tracking and Adjusting Targets using Power Query
Hi all, I’m currently working with a fairly large data set (a sample of which is provided in the link below). I am tracking the number of respondents to a survey, and have created a “have/required”...
To be general, you may create a custom column with IF statement to control the result with M code like pattern below:
Column = if ([collected] / [needed]) > 1 "" else [collected] / [needed]
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To be general, you may create a custom column with IF statement to control the result with M code like pattern below:
Column = if ([collected] / [needed]) > 1 "" else [collected] / [needed]
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.