How to show only Up to Last Month data based on Current Date

[Vikas_Mattela]

Hi,

In below visual I am showing comparion between Current Year and Last Year. But since other visual dependent on tables, where it has data till last month (septmber). So for this visual I would like to show Current Year till September only, Last Year will be till December.

[mh2587]

MaxDateIsToday = IF(MAXX(YourTable, YourTable[YourDateColumn]) <= TODAY(), 1, 0)
//Use this a visual filter or page filter 

[Vikas_Mattela]

Thanks for your reply @mh2587 . I have folllowed same thing, but my requirement is Last Year values has to show till December. Current Year has to show till October. But as per your formula its filtering both CY and LY.