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 n...
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.
Anonymous ,
Use this measure in visual or as a visual level filter
countrows(filter(Table, Table[Due date] < eomonth(Today(),0) ))