Measure - End OF Month based on slicer

Hi, I'm trying to create a measure that will vary based on a slicer selection. My table has 3 columns. (Date - Index Name - Value) Currently, I only have 3 index (Index A, Index B & Index C) I...

Need Help

Zubair_Muhammad
8 years ago
Hi Guillaume,

Check this one please

=Calculate(Max(Table1[Date]),filter(Table1,Table1[IndexName]=earlier(Table1[IndexName])&&Month(Table1[Date])=Month(Earlier(Table1[Date]))))

Regards,
Zubair
v-yulgu-msft
8 years ago
Hi gcyr,

You can also try this workaround:

Create a Month column in your source table: Month = Table1[Date].[Month]

Create a measure like: Last Date = MAX(Table1[Date])

Then, add [Index Name], [Month] and [Last Date] into table visual. It will automatically display last date per Index per month.

Best regards,
Yuliana Gu