Forum Discussion
3 full months trailing graph
Hi SammyNed ,
Thanks for the reply from SachinNandanwar , please allow me to provide another insight:
I use these sample data to demonstrate.
1. create a calculation table. And adjust the date format.
Table = DISTINCT(‘financials’[Date])2. create MEASURE.
MEASURE = VAR _cur_mon = EOMONTH ( SELECTEDVALUE ( ‘Table’[Date] ), 0 ) VAR _3_mon = EOMONTH ( SELECTEDVALUE ( ‘Table’[Date] ), -3 ) + 1 RETURN IF ( MAX ( ‘financials’[Date] ) <= _cur_mon && MAX ( ‘financials’[Date] ) >= _3_mon, 1 )
3. Filter the data in the bar chart where MEASURE is 1.If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SammyNed ,
Thanks for the reply from SachinNandanwar , please allow me to provide another insight:
I use these sample data to demonstrate.
1. create a calculation table. And adjust the date format.
Table =
DISTINCT(‘financials’[Date])
2. create MEASURE.
MEASURE =
VAR _cur_mon =
EOMONTH ( SELECTEDVALUE ( ‘Table’[Date] ), 0 )
VAR _3_mon =
EOMONTH ( SELECTEDVALUE ( ‘Table’[Date] ), -3 ) + 1
RETURN
IF (
MAX ( ‘financials’[Date] ) <= _cur_mon
&& MAX ( ‘financials’[Date] ) >= _3_mon,
1
)
3. Filter the data in the bar chart where MEASURE is 1.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you Anonymous . This really helped. I think my issue was with the date table (it was in days and not months)
