Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Working with 2 Dates

Hello guys,, ive been wondering how can i do these I have a date "Request date" and "Completion date" I want to see the total request in a month and see the no of completed request that are no...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi @anthonycarreon,

     

    In you scenario, Userelationship function should help.

    Here’s my sample data:

    Please check following steps as below:

    1. Manage relationships between two tables:

    2. Create measures:

        no of complete = CALCULATE(COUNT('Table'[complete]),USERELATIONSHIP('Date'[Date],'Table'[complete]))

        no of request = CALCULATE(COUNT('Table'[request]),USERELATIONSHIP('Date'[Date],'Table'[request]))

    3. Result would be shown as below:

    BTW, Pbix as attached. Hopefully works for you.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi @anthonycarreon,

 

In you scenario, Userelationship function should help.

Here’s my sample data:

Please check following steps as below:

1. Manage relationships between two tables:

2. Create measures:

    no of complete = CALCULATE(COUNT('Table'[complete]),USERELATIONSHIP('Date'[Date],'Table'[complete]))

    no of request = CALCULATE(COUNT('Table'[request]),USERELATIONSHIP('Date'[Date],'Table'[request]))

3. Result would be shown as below:

BTW, Pbix as attached. Hopefully works for you.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for you Feedback Sir, 😉
    kudos