Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi
I have one table, in that i have two emploees in different row, what i want to to check that if one of them is on holiday at same date i need to show that its not allowed if one is on holiday then ok but when i tried this its showing on all day off not allowed but i want when both of them are on holiday at same day. like on may 1 employees have day off in last column. Please help thanks
Solved! Go to Solution.
Hi @ziyabikram96 ,
First, please show your sample data as excel or pbix file instead of picture to us. Then, I am quite mess up in your description about the expected output. Would you please explain more about it and show us expected output?
Thank you for your support and understanding.
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
Hi @ziyabikram96 ,
First, please show your sample data as excel or pbix file instead of picture to us. Then, I am quite mess up in your description about the expected output. Would you please explain more about it and show us expected output?
Thank you for your support and understanding.
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
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 54 | |
| 39 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 98 | |
| 84 | |
| 35 | |
| 30 | |
| 25 |