Create table from another by filtering data with values in date

Question

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 add dates with value and not empty?

Thank you!

datainsights · Accepted Answer

Don't @JessicaM,
 
Try this calculated table:
 
NewTable = FILTER ( Table1, NOT ISBLANK ( Table1[date3] ) )
 
Source data (Table 1):

Result:

Forum Discussion

Create table from another by filtering data with values in date

2 Replies

Related content

Slicer Filtering Another slicer

Filter depending on another filter

Creating a measure that is the value of another measure but ignores a filter

Creating a Date Filter in Power BI

Creating a Measure: Filtering Text Column, with text from another column