Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Create table from another by filtering data with values in date

Hello! I have several data sources. I need to create from an existing table, the specific values that do not have data in the "date3" column of the source table. How can I filter so that I only ...
  • DataInsights's avatar
    DataInsights
    5 years ago

    Don't @JessicaM,

    Try this calculated table:

    NewTable = FILTER ( Table1, NOT ISBLANK ( Table1[date3] ) )

    Source data (Table 1):

    DataInsights_0-1615259046592.png

    Result:

    DataInsights_1-1615259066130.png