Forum Discussion
Calculate Expected Entries
Hi, I have a a dataset which constains a number of floors which are used to carry out heath and safety checks, these are categorised into buildings. I want to flag when an entry has not been complete...
I would like a measure to instead display text instead of values for those that are higher or lower than my expected value that's what I am trying to achieve.
Hi Anonymous ,
Would you please show us some sample data and your expected output for a better understanding? Maybe you need unpivot steps in your raw data.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I managed to figure it out myself by grouping my data via power query then providing a measure to stipulate if the column was less than 1 to class it as missing data. Thank you for all your suggestions though.