Hi,
I`m trying to write a query in power query and have an issue. In the input table I have two columns - "Work Schedule Hours" and "Hours". Within "Get and Transform" I would like to add a custom column which does two things:
1. Divides Column "hours" by "work schedule (hours)" to give a number - 1 or less (based on report this will always be less than 1). Lets name the custom column "Days Absent"
2. I would then like to filter with two rules which are basically if Column "Abs. code" is PTMG then keep the row regardless of the figure in column "Days Absent", however, if the "Abs. code" column contains any other info then discard the row(s) if the figure in "Days absent" column is less than 1
Please can someone look. Have attached a data file with a query which creates the extra column "days absent" but does not filter out the rows.
Thanks,
B
Bookmarks