Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good afternoon,
I have the following table
I want to create a conditional in which if the total approved amount is more than 50 and is Dinner subtract 50(day limit dinner) if the value is less keep it 0 and if the total is more than 30 and is luch subtract 30(day limit luch) if the total is less kee ipt 0. I have the following formula:
I would create a conditional column under "Add Column" in Power Query Editor.
There you can spell out your conditions.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |