countifs in DAX Filter by 3 dates

Anything related to PowerPivot and DAX Formuale
reggieneo
Posts: 1
Joined: Fri Aug 23, 2019 7:55 pm

countifs in DAX Filter by 3 dates

Postby reggieneo » Sat Aug 24, 2019 12:33 am

Hi All'

In excel I can count projects with filter of start date, projects before the end date and date of current cell or selected cell value as reference.

How can I do this in Dax? Formula and Result in G2 : "=COUNTIFS($B$2:$B$16,"<"&E2,$C$2:$C1$6,$E$2)".

please see data for reference
A B C D E F G
proj 1 5-May-19 2-Aug-19 2-Aug-19 Result 9
proj 2 6-May-19 3-Aug-19
proj 3 7-May-19 4-Aug-19
proj 4 8-May-19 8-May-19
proj 5 9-May-19 2-Aug-19
proj 6 2-Jun-19 2-Aug-19
proj 7 3-Jun-19 2-Aug-19
proj 8 4-Jun-19 2-Aug-19
proj 9 5-Jun-19 2-Aug-19
proj 10 9-Jul-19 2-Aug-19
proj 11 10-Jul-19 2-Aug-19
proj 12 11-Jul-19 2-Aug-19
proj 13 2-Aug-19 2-Aug-19
proj 14 2-Aug-19 2-Aug-19
proj 15 2-Aug-19 3-Aug-19

appreciate the help,
reggieneo

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests