Need help with DAX

hi, I'm bringing data from sap using direct query. I have view which already has fiscal year and fiscal period. The fiscal year follows sap calendar and there fiscal year starts on 2nd thursday of...

Need Help

HarishKM
1 year ago
DiKi-I Hey,
you can follow this blog post - Unique Time Intelligence Analysis Examples for Pow... - Microsoft Fabric Community

I hope this will fulfill your requirement.

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

lbendlin

Super User

1 year ago

In that case you can use the WINDOW or OFFSET function to go back x periods.

WINDOW(-2,REL,0,REL,...)

Anonymous

Not applicable

1 year ago

Hi DiKi-I,

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

Forum Discussion

Need help with DAX