Forum Discussion

KevinGesquiere's avatar
KevinGesquiere
Frequent Visitor
8 years ago

Table with measures over different periods

Is it possible to show a table with measures over different periods? It probably does, but how should I get started?

To be more precise, the data is coming from an orders table where we want an overview of the following measures.

 

 Last 6 monthsLast 2 monthsLast month
% open orders.........
% closed orders < 5days.........
% closed orders 5-15days.........
% closed orders > 15days.........

 

Thanks

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi KevinGesquiere,

     

    We may create a matrix to get your output.

    Is it possible to show a table with measures over different periods? It probably does, but how should I get started?

    To be more precise, the data is coming from an orders table where we want an overview of the following measures.

     

    For the measures about calculate the orders last month, last 2 month or last 6 month, you could have a reference of this similar thread.

     

    If you need the further help, please share some data sample which can reproduce the scenario and your expected output, so that we can help further investigate on it?

     

    Best Regards,

    Cherry

     

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi KevinGesquiere,

     

    Have you solved you problem?

     

    If you have solved, you could share your solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

    Best regards,

    Cherry