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
Larry_Wang
Helper I
Helper I

How to create a table using DAX

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 IDLeave Date
ID01 
ID0210/10/2021
ID03 
ID0411/5/2021
ID0511/6/2021
ID06 
ID0712/4/2021
ID088/26/2021
ID09 
ID109/15/2021
ID11 
ID1211/7/2021
ID133/28/2021
ID147/9/2021
ID157/10/2021
ID16 
ID179/25/2021
ID18 
ID19 

 

Thanks,

 

Larry

1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

Hi,

Here is an example:

Nonblank = FILTER(nonblanktable,nonblanktable[Leave Date]<>BLANK())
ValtteriN_0-1639638461565.png



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!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ValtteriN
Super User
Super User

Hi,

Here is an example:

Nonblank = FILTER(nonblanktable,nonblanktable[Leave Date]<>BLANK())
ValtteriN_0-1639638461565.png



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!





Did I answer your question? Mark my post as a solution!

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

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.