A secundary table from a main table

[avioti]

Hello All

I need your help

I have a table called incidents. This is my main table. I would like to create the same table with all of columns, but I would like to put in this new table only incidents whose contain the close date <> BLANK().

Is is possible to create this kind of table?

[DoubleJ · Accepted solution]

Hello

You can use the "New Table" option and use this formula to fill your table

IncidentsSolved = CALCULATETABLE(Incidents;ISBLANK(Incidents[CloseDate]) = FALSE()) 

Hope this helps!

JJ

[avioti]

Thanks

I will try it

🙂