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
The first link makes sense. Thanks a ton Greg
1. I have created the measure for Open tickets but how do I showcase only the open tickets for This Week (Monday to Sunday as mentioned above) and Last Week. So the This Week and Last Week should be like a Slicer checkbox so it will show for that week open tickets.
Can you share examples how to use relationships based on the model I have above?
This analysis I have been searching for on the Community since ages though there is a plethora of information never have come across any content that will kind help me show a simple count of tickets based on This Week, Last Week and This Month and Last Month and Tickets open and closed as on Today. I feel if I get this my other analysis would be sorted for sure.
Also below is the screenshot of the measure I have created but how do I know if its based on Created Date or Resolved Date based on my connection Above?