Month details from Two diffrent columns

Question

Hi all,I need a help with some calculationI have a table with two date columns ,i need to have monthly count of some detailstableservice idstartdatecompletion date123451/1/2024&nbsp;1010113/1/202415/1/2024143562/2/202416/2/2024i want the result like thisMonthcount of service id startedcount of service id completdJan21Feb11please help me solve it&nbsp;

ryan_mayu · Accepted Answer

Ashik008&nbsp;
you need to create a calendar table and create two measures
start count = count('Table'[startdate])

complete count = CALCULATE(COUNT('Table'[completion date]),USERELATIONSHIP('Table'[completion date],'Table 2'[Date]))

pls see the attachment below

Forum Discussion

Month details from Two diffrent columns

1 Reply

Related content

Two measures with diffrent slicer selection for same column

Missing Connection Details

Pricing in details

Fabric capacity metrics - Timepoint Detail

metric details for onelake storage

service id	startdate	completion date
12345	1/1/2024
10101	13/1/2024	15/1/2024
14356	2/2/2024	16/2/2024

Month	count of service id started	count of service id completd
Jan	2	1
Feb	1	1