Hi, I tried to create DAX measure that will flag every end of latest available date each month to one. Later on, I am going to use this measure as visual level filter. The illustration is given in the table below.
a. In January 2018, the latest available date is 10 Jan 2018, so that row will be flagged to 1
b. In February 2018, the latest available date 28 February 2018, so that row will be flagged to 1
c. in March 2018, the latest available date is 2 march 2018, so that row will be flagged to 1.
d. the rest of the rows will be flagged to 0
I was thinking to use Calculate function combined with ENDOFMONTH Function like
FlagEOFMONTH = CALCULATE(1,FILTER(MyTable,ENDOFMONTH(MyTable[DateNational]))), but it does not works
Any idea about how to generate correct dax measure ?