Forum Discussion

caitertotz's avatar
caitertotz
Regular Visitor
8 years ago
Solved

Find last value based on date

I have been racking my brain for days now trying to get this to work. I have a series of data each with several dates for each month, I need my report to ONLY show me the last current date of the mon...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi caitertotz,

     

    You could get your expected output by the following steps.

     

    1. Create a calculated table below to get the Week of value.

     

    Table = VALUES(Table1[Week of ])

    2. Create a measure below in the Table to filter.

     

    selected = 
IF(SELECTEDVALUE(Table1[Week of ]) = MAXX(ALLSELECTED('Table'),[Week of ]),1,0)

    3.  Put the selected measure in Visual level filters and create the visual.

     

     

     

    In addition, you could have a reference of my test pbix file.

     

    Hope it can help you !:smileytongue:

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi caitertotz,

 

You could get your expected output by the following steps.

 

1. Create a calculated table below to get the Week of value.

 

Table = VALUES(Table1[Week of ])

2. Create a measure below in the Table to filter.

 

selected = 
IF(SELECTEDVALUE(Table1[Week of ]) = MAXX(ALLSELECTED('Table'),[Week of ]),1,0)

3.  Put the selected measure in Visual level filters and create the visual.

 

 

 

In addition, you could have a reference of my test pbix file.

 

Hope it can help you !:smileytongue:

 

Best Regards,

Cherry