How to get the sales data from next month to fiscal year end month

[sunil222]

How to get the sales data from next month to fiscal year end month

fiscal year : April to March , In my case i need the sales data from Feb 24 to march 24.

when we are in march 2024 need that march2024 data,            we are in (April 2024) - need may 2024 to march 2024

Please help me on this. should be dynamic

[v-jingzhan-msft]

Hi @sunil222 

What is the granularity of your data? Daily or monthly? Can you show some sample data (dummy data) and expected result in table format? This can help us understand the problem and provide a possible solution more quickly. 

Best Regards,
Jing

[sunil222 · Accepted solution]

got the solution ...thanks