Countif multiple dates in Power query

[BYENER]

Hi,

I hope someone can help me. I have a table (A) with two date columns. In another table (B) I have one date column. I want to show in table B how many rows match my criteria. See below: I want to do this in Power Query and do not want to work with DAX.

Count row if column C > F3 and column A < F3

Thanks a lot!

[BYENER]

@amitchandak super this works fine!

[amitchandak · Accepted solution]

@BYENER , You have create a new column in Power Query in table 2. File is attached below after signature

let
_1 = [Column1],
_table = Table.SelectRows(DateRange, each [Date1] <= _1 and (if [Date2] =null then DateTime.Date(DateTime.FixedLocalNow()) else [Date2]) >= _1),
_count = Table.RowCount(_table)
in 
_count