Forum Discussion

Frequent Visitor

5 years ago

Creating a Slicer in a complex FY Calendar

Hello, The company I work for has a complex FY calendar which it just doesn't start in July but also the day it starts is based on a 4-4-5 weeks grouping into a month for that quarter. Just to e...

Need Help

Show and Tell

amitchandak

Super User

5 years ago

Murphy , Try this for MTD, same way you can get QTD and ytd

var _min = minx(filter('Date', 'Date'[Date] = today()),[FY Month])
var _st = minx(filter('Date', [FY Month]= _min),[Date] )
return
calculate(sum(Table[Value]), filter(all('Date') 'Date'[Date] >=_st && 'Date'[Date] = Today()))

Change _min and _st