Forum Discussion
Show data until today in dashboard
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
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.
2 Replies
- amitchandak
Super User
Anonymous ,
Use this measure in visual or as a visual level filter
countrows(filter(Table, Table[Due date] < eomonth(Today(),0) ))
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.
