count a field when this field is between 2 date

[Anonymous]

Hello ,

I own a table with several fields . On the list of field we can find a column date and an other column "id" .

I want calculate the quantity of id whose appeared between 2 dates. For example between 1 may 2019 and 1 june 2019.

I use this expression :

macolonne = CALCULATE(count(matable[numero]),DATESBETWEEN(matable[date_effet],DATE(2019,5,1),DATE(2019,6,1)))

 Have you an idea to unlock this issue ?

[parry2k]

@Anonymous is your date fixed? Do you want to select the date range? Are you not getting expected result with the expression below? How you are visualizing the data?

[Anonymous]

Hella @parry2k ,

Here is my expression :

Date_of_today = CALCULATE("1";DATESBETWEEN(my_table[date_start];DATE(year(my_table[date_start]),6,1);DATE(year(my_table[date_start]),7,1)))

If the date of today is between DATE(year(my_table[date_start]),6,1) and DATE(year(my_table[date_start]),7,1) > write "1" on the line , else write 0

For powerbi this "expression" it's an erreur " Date_of_today = CALCULATE("1";DATESBETWEEN(my_table[date_start];DATE(year(my_table[date_start]),6,1);DATE(year(my_table[date_start]),7,1))) " and software can't generated the result ...

[Anonymous · Accepted solution]

Hello,

After scaring with dax here is a expression to calculate / write in automatic a value between 1 and last day of current month :

field2 = if
(
 AND(
     date(year(ma_table[date_truc]);month(ma_table[date_truc]);day(ma_table[date_truc])) >= date(year(TODAY());month(TODAY());1)  
	 ;
     date(year(ma_table[date_truc]);month(ma_table[date_truc]);day(ma_table[date_truc])) < date ( if(Month(TODAY())=12;YEAR(TODAY())+1;YEAR(TODAY())) ; if(Month(TODAY())=12;1;Month(TODAY())+1) ; 1 ) 
    )
;
"oui"
;
"non"
)