sum per time (month) using start and end date from table

Question

&nbsp;Hi all,I am very new to power bi and would appreciate some help. Have a table something like the one below&nbsp;countStartDateEndDate251/1/20213/31/2022173/1/202112/31/2021326/1/20216/1/2022447/1/202110/31/2022141/1/202212/31/2022211/1/20213/31/2022102/1/202212/31/2022&nbsp;from this I would like to create a graph as shown below where a total sum from all rows that the month is in the range of the start and end date:&nbsp;thanks in advanceRom&nbsp;&nbsp;

greg_deckler · Accepted Answer

Rom_A&nbsp;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/409364https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

Forum Discussion

sum per time (month) using start and end date from table

2 Replies

Related content

Start Month and End Month Separate Slicers

Month to Month Flow Calculation

month start date

Count Student Starts per month

Lakehouse Cold Start

count	StartDate	EndDate
25	1/1/2021	3/31/2022
17	3/1/2021	12/31/2021
32	6/1/2021	6/1/2022
44	7/1/2021	10/31/2022
14	1/1/2022	12/31/2022
21	1/1/2021	3/31/2022
10	2/1/2022	12/31/2022