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

Does your semantic model have a calendar table that is clearly reflecting these custom fiscal periods? You will need to create your own time intelligence measures.

DiKi-I
Post Partisan
1 year ago
I don't have any calendar table. The fact table coming from source has fiscal year, period , week, date . Basically its a flat table from the source.
- lbendlin
  Super User
  1 year ago
  Sorry to hear that. Performance will be horrible at best. Do your SAP queries fold?
  - DiKi-I
    Post Partisan
    1 year ago
    I tested it and can see native queries so I believe it is folding.

Forum Discussion

Need help with DAX