Forum Discussion
DouweMeer
Impactful Individual
Impactful IndividualPreviousyear excluding a filter
To start, I received a deadline for Friday and have been breaking my head over this for the past few weeks. My problem is dat previousyear works as you expect. Within its own context it makes a cal...
amitchandak
Super User
Super UserDouweMeer ,Please check: https://www.dropbox.com/s/vighl8efolwisj4/previousYear_yearand%20date.pbix?dl=0
I converted to date and used time intelligence
DouweMeerImpactful Individual
Impactful IndividualWas one of my attempts as well. What you get is due to the 1 to many relationship one way that products duplicate in a year. Once as a maintain and once as 'new'. The problem lies in the previousyear once again.
A is an example, B has this for 2019 as well. C has it in 2020 as it is the first year it is 'maintained'.