How to create a table using DAX

[Larry_Wang]

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

[ValtteriN · Accepted solution]

Hi,

Here is an example:

Nonblank = FILTER(nonblanktable,nonblanktable[Leave Date]<>BLANK())

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!

[Larry_Wang]

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