Find duplicates between "date selected" and "date selected" - 30 days
Hi! 🙂 I have date filters (slicer) for year, month and day in a model that uses a table with [ID] and [Date] I want to show the duplicates between the "Date selected" and ("Date selected" -30 days) This is the table: If i select "December 1st, 2022" it should only show these: Thank you!
Events for a Period time
Hello I'm begings to use Power BI and I'm interesting to know if someone can help. Problem: How to measure the correct Duration by Hour? If I sum the column"Hour" I get a wrong value of 143 instead of 104.18 as table below. My doubt is I need to duplicate the rows breakdown the times or it's possible a metric to analize the data. Start End Duration (sec) hour 2022-09-09T07:58:15.753 2022-09-09T07:58:21.820 6 7 2022-09-09T07:58:21.820 2022-09-09T08:00:38.357 137 7 2022-09-09T08:00:38.357 2022-09-09T08:04:48.450 250 8 Hour SUM_Duration by hour Sum_Duration by period 7 143 104.18 8 250 288.82
