Forum Discussion

Ashik008's avatar
Ashik008
Frequent Visitor
2 years ago
Solved

Month details from Two diffrent columns

Hi all, I need a help with some calculation I have a table with two date columns ,i need to have monthly count of some details table service id startdate completion date 12345 1/1/2024 ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Ashik008 

    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

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Ashik008 

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