Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ziyabikram96
Helper V
Helper V

comparing two rows and getting matched data

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 

Capture 2.JPG

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-deddai1-msft
Community Support
Community Support

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.