Forum Discussion

BYENER's avatar
BYENER
Helper V
3 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

     

amitchandak's avatar
amitchandak
Super User
3 years ago

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