Forum Discussion
Solved
Power query formula help
Hi all, I have a set of data that requires me to set up personnel that is active/inactive. The dataset is about a set of professional that took exam on certain timeframe. The dataset samp...
Hi, it works. I've updated Source data:
Result:
But maybe I don't understand what do you really need. Could you upload your data to google drive for example and provide a link?
Maybe you want something like this (I've attached pbix file):
Filtered Dec-23:
Hi there, I tried running your formula using an updated data as below.
| Exam Session | Name |
| Dec-23 | A |
| Jun-23 | A |
| Dec-22 | A |
| Jun-23 | B |
| Dec-22 | B |
| Dec-22 | C |
| Jun-23 | D |
| Jun-22 | E |
| Jun-24 | C |
| Jun-24 | E |
However, the formula doesnt sync as the updated version. It's still showing Dec-23, Jun-23, Dec-22 and Jun-22 as follows.
My final plan if to have a slicer selecting the session (datemonth) and showing the candidate if its active or non-active
Hi, it works. I've updated Source data:
Result:
But maybe I don't understand what do you really need. Could you upload your data to google drive for example and provide a link?