Show data until today in dashboard

[Anonymous]

Hello everyone, I need help with this problem, I have to show in a dashboard the months so far including ALL september

For example, for this case, I have all these CAPAS (record type), and i need to show 
Capa:
capa 010
capa 064
capa 067

due date:

30/4/2022
31/8/2022

30/9/2022

not including 31/10/2022 (capa 0695)

Thanks everyone

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
VAR cur_due_date =
    SELECTEDVALUE ( 'Table'[Due Date] )
VAR cur_date =
    TODAY ()
RETURN
    IF ( MONTH ( cur_due_date ) <= MONTH ( cur_date ), 1, 0 )

3. add a table visual with "Table" column, and add this measure to table visual filter pane

Please refer the .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

Use this measure in visual or as a visual level filter

countrows(filter(Table, Table[Due date] < eomonth(Today(),0) ))