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 Every one,
I have a table below and in the Leave Date column there are some blank entries. I want to create a new table that not including the blank date ( only contains user id with leave date ). How to do this in DX?
User ID | Leave Date |
ID01 | |
ID02 | 10/10/2021 |
ID03 | |
ID04 | 11/5/2021 |
ID05 | 11/6/2021 |
ID06 | |
ID07 | 12/4/2021 |
ID08 | 8/26/2021 |
ID09 | |
ID10 | 9/15/2021 |
ID11 | |
ID12 | 11/7/2021 |
ID13 | 3/28/2021 |
ID14 | 7/9/2021 |
ID15 | 7/10/2021 |
ID16 | |
ID17 | 9/25/2021 |
ID18 | |
ID19 |
Thanks,
Larry
Solved! Go to Solution.
Hi,
Here is an example:
I hope this helps to solve your issue and if it does consider accepting this as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Here is an example:
I hope this helps to solve your issue and if it does consider accepting this as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi @ValtteriN
Thank you again for the quick and good solutions on this issue. It is really what I want.
Have a nice day!
Larry
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |