Forum Discussion
id013
Helper V
Helper VAnyone having issues using USERELATIONSHIP and filters?
So I have a table that shows product sales. There is a purchase date and a return date as well as a field that states whethere they are within 30 days of purchase date, there is also a "Within 30 Day...
amitchandak
Super User
Super UserNot sure I got it but if you want to move one the day +/- 30 days try like
-30 = CALCULATE(SUM(purchase[Amount]),dateadd('Date'[Date],-30,day),userelation(..))
+30 = CALCULATE(SUM(purchase[Amount]),dateadd('Date'[Date],30,day),userelation(..))
If you want to use some kind clause with both dates, refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.
- id013
hi amitchandak
Unfortunately I don't have control over the fields and the within_30_days field is actually just a True\False value that gets updated.
- amitchandak
What exactly you want to do with that 30 day filter. Can you explain with example
