Airport Delays and Covid Cases Pivot Table
I have two tables joined to a Date lookup table. My flight data doesn't have data for October 2021 to December 2021 but my cases data does. How do I exclude the blank rows automatically without have to click filter blank rows manually. Is this possible using a DAX formula or do I have to do the inner joins in power query before using Power Pivot.
I have two tables joined to a Date lookup table. My flight data doesn't have data for October 2021 to December 2021 but my cases data does. How do I exclude the blank rows automatically without have to click filter blank rows manually. Is this possible using a DAX formula or do I have to do the inner joins in power query before using Power Pivot.
