Forum Discussion

Larry_Wang's avatar
Larry_Wang
Helper I
4 years ago
Solved

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 dat...
DAX
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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!

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

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's avatar
Larry_Wang
Helper I
4 years ago

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