Table with measures over different periods

[KevinGesquiere]

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 months	Last 2 months	Last month
% open orders	...	...	...
% closed orders < 5days	...	...	...
% closed orders 5-15days	...	...	...
% closed orders > 15days	...	...	...

Thanks

[v-piga-msft]

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

[v-piga-msft]

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