Forum Discussion
Solved
Countif multiple dates in Power query
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 , 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
2 Replies
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 _countamitchandak super this works fine!
