Hi I have the formula below that tells me what the current month is. I use it in slicers and filters.
What I would like is a dax formula for MTD. IE on the 28th of the month I would need all sales from 1-28. I would like to use a slicer or filter for it.
Maybe "CURRENT MTD"
=if(month(dCalendar[dateS])=month(today()) && year(dCalendar[dateS])=year(today()),"Current Month",dCalendar[Month])
Thanks
What I would like is a dax formula for MTD. IE on the 28th of the month I would need all sales from 1-28. I would like to use a slicer or filter for it.
Maybe "CURRENT MTD"
=if(month(dCalendar[dateS])=month(today()) && year(dCalendar[dateS])=year(today()),"Current Month",dCalendar[Month])
Thanks