Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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.