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 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

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!

2 Replies

  • 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