Forum Discussion
yashwant101
Helper III
Helper IIIDynamic value in Slicer
Hi all, I have a scenario where I need to calculate months till now of different records. In the below case we need to give one more slicer for months till now for each record: The ...
amitchandak
Super User
Super Useryashwant101 , Based on what I got so far. You can join the Transaction date with the date of date table
and have measure like
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
You can min date if you need date
minx(DATESMTD('Date'[Date]), Date[Date])
yashwant101Helper III
Helper IIIHi amitchandak ,
Thanks for your response, but as per my requirement I need to pull the field in a slicer and we cannot pull measure in a slicer.