Forum Discussion
Last Week vs This Week and Last Month vs This Month
Community ChampionAnonymous You can use USERELATIONSHIP in your measures.
Also, these might be useful:
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Also to add on to the Thread.
Below is the screenshot of the Incident Table which I import into PowerBi using Import mode.
When I use the below filters and selected Created Date as This Week it takes from 30-08-2021 00:00:00 PST (Monday) to 5th September 23:59:59 (Sunday). So when I run it the count shows 69 and according to my Measure based on Created Date itself it says 77 and now when im checking its 80. Not sure whats the issue. Im sure there is some issue with the measure