cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshuareddy Frequent Visitor
Frequent Visitor

Dynamic measure to display results for current year and previous 2 years

Hi, 

I have a measure which works fine but I want it to display the results dynamically for current year and last 2 years instead of me manually selecting the years 

Is it possible?

 

Heres my current measure:

 

1. DistinctAccount = DISTINCTCOUNT('AccountTable'[AccountId])

 

2. AccountMembers= CALCULATE(
[DistinctAccount],
FILTER(
ALLSELECTED('Calendar'[Date]),
('Calendar'[Date] <= MAX('Calendar'[Date]) 
))
,FILTER(ALLSELECTED(Id_Table[Termination Year]),(Id_Table[Termination Year]>SELECTEDVALUE('Calendar'[Year])))

Please let me know

 

Thanks

1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamic measure to display results for current year and previous 2 years

Hi @joshuareddy,


I have a measure which works fine but I want it to display the results dynamically for current year and last 2 years instead of me manually selecting the years 

 


I'm not very clear about your requirement "display the results dynamically for current year and last 2 years instead of me manually selecting the years ".

 

Do you want your measure will show the value without selecting date in slicer?

 

If it is convenient, could you share some data sample and your desired output so that we could understand your scenario better and get the solution more quickly.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.