Day, Week, Month Offsets

DAX DAX Calculations
1

Hello!

I’m trying to create Month, Week, Day offset columns for time intelligence purposes. I’ve attached our fiscal 445 calendar. We are currently in FY26 and period 9 (2/2 is the start of the fiscal year) so it makes adjusting the time confusing.

Date.pbix (290.3 KB)

Thanks in advance!

2

Hi @jsamstad ,

Thanks for reaching out.

While we wait for responses from our Learning Community, I went ahead and posted your question using the Explain Simply feature in Data Mentor. Here are a couple of insights you might find useful in the meantime.

We also encourage you to explore the tool directly—it’s a great resource for quick, simplified explanations on a wide range of data topics:
:link: https://mentor.enterprisedna.co/explain-simply

image
image975×432 108 KB

image
image975×599 147 KB

Cheers,
Your Enterprise DNA Support Team

3

Hi @jsamstad - Did response from EDNA provided solution or still help is needed.

Thanks
Ankit J

4

I used another program (Alteryx) to figure it out. You may close the topic.

1 Like