Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Shared time axis on 2 different dates

Hi,   Here is a sample : ticket_number creation date closure date ticket 1 02/01/2019 02/01/2019 ticket 2 05/01/2019 06/01/2019 ticket 3 10/01/2019 11/01/2019 ticket 4 15/0...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    You can create calculate column using DAX like pattern below:

    Created = CALCULATE(COUNT(Table1[ticket_number]), FILTER(Table1, MONTH(Table1[creation date]) = MONTH(EARLIER(Table1[creation date]))))

Closed = CALCULATE(COUNT(Table1[ticket_number]), FILTER(Table1, MONTH(Table1[closure date]) = MONTH(EARLIER(Table1[closure date]))))

      

     

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You can create calculate column using DAX like pattern below:

Created = CALCULATE(COUNT(Table1[ticket_number]), FILTER(Table1, MONTH(Table1[creation date]) = MONTH(EARLIER(Table1[creation date]))))

Closed = CALCULATE(COUNT(Table1[ticket_number]), FILTER(Table1, MONTH(Table1[closure date]) = MONTH(EARLIER(Table1[closure date]))))

  

 

Community Support Team _ Jimmy Tao

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
    7 years ago

    Thanks v-yuta-msft , that works for Created and Closed, do you have an idea how to calculate the rolling difference, please ?

    Thanks

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Anonymous ,

       

      Could share more details/logic about "Rolling Difference" you mentioned?

       

      Community Support Team _ Jimmy Tao

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