Hope you are well.
I have created 2 simple measures
- Open Jobs ( Calculates all the jobs that are open)
- Open Jobs 5 days old (Calculates all the jobs that have been open for 5 or more days)
Issue: When I use the Open Jobs 5 days old against the user context to see how many of these each user have, I get an error like before. I looked up online and can’t seem to find a way around. Is there a correct way of doing this?
I have attached a sampleDateAdd Help.pbix (164.7 KB) pbix file that replicates the scenario.
Appreciate all your help.