Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Guys
I have the table below. The idea is to create a calculated column (in blue) to represent Actuals (A) vs Budget (B), for each month, quarter, product, reps etc..
Any ideas
Thanks
Solved! Go to Solution.
Hi ckolahi
Please try this code
@Anonymous
super thanks it works. However I think y example was misleading. What would be if the B value was not the Max value ?
I tried to create variable actuals (A) vs (B) with FILTER function, was not successful.
If any ideas please feel free.
Thanks
Hi ckolahi
Please try this code
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |