Return a new table based on : Show All columns in a table which satisfy a condition

[Aishwaryazanpur]

Hi ,

I want to create a kind of  metric data collection report, in which I want to check if a country has submitted the data on a particular deadline , for which I have an original data table with many columns and I have created table in query editor which has "Reporting Month", "Country" and the "deadline date" for data submission. I am joining these 2 tables based on the column "Reporting Month" because there is no date column in the original table.

Basically, I want to return a table with all columns from the original table in which values are still zero beyond deadline date, how could I achieve this , please help!

[v-yaningy-msft]

Hi, @Aishwaryazanpur 

You can describe your needs in detail along with the images, for the time being, you don't understand how you want to realize it; if possible, you can share the pbix file without sensitive data for testing.

Best Regards,
Yang
Community Support Team