Forum Discussion
DAX
I think it's simple but need your help. If I select a date in slicer then I have to show all dates of that month till selected date in slicer.
Anonymous , Create an independent date table as suggested in
https://www.youtube.com/watch?v=duMSovyosXE
and try formula like this
Measure = var _1 = DATESMTD('Sales date'[Dates]) return CALCULATE(sum(Sales[Sales]), filter(Sales,Sales[Date] in _1))
it's not working. it gives error.
Anonymous , Create an independent date table as suggested in
https://www.youtube.com/watch?v=duMSovyosXE
and try formula like this
Measure = var _1 = DATESMTD('Sales date'[Dates]) return CALCULATE(sum(Sales[Sales]), filter(Sales,Sales[Date] in _1))