Forum Discussion
Helper IISales over the year with Dynamic year value
Community SupportHi Parihar1980
I'm afraid no direct feature can achieve this, Here is a workaround.
1. create a calendar table (table2) and manage relationship between two tables.
2.create measures in Table2, then add "year" column from Table 1 to the slicer.
Measure = SELECTEDVALUE(Table2[year])
Measure 2 = [Measure]-MAX('Table'[year])
Measure 3 = IF([Measure 2]>=0&&[Measure 2]<5,1,0)
3. add [measure3] to Visual Filter.
Finally, it works as your requirement
Best Regards
Maggie
Helper IImany thanks for your feedback. But I am using tabular model and I can't see this funcation while importing my model (SSAS) and using this i am creating my report.
Also SELECTEDVALUE funcation working in Direct query OR Import Mode not with tabular model
Any help or suggestion ?
- Ashish_Mathur
Super User
Hi,
To keep things simple, why can you not just select 5 years instead of just 1?
- Parihar1980
As per my requirement we have to show data based on selected Year value, so If User will select 2018 we have to diplay record from 2018,2017,2016,2015 and 2014. and As i menationed SELECTEDVALUE funcation is not working in tabular model. So I have to found some ways to display data based in user selection
- Ashish_Mathur
Hi,
I can try to solve it with the DATESBETWEEN() function. Share the link from where i can download your PBI file.
