Forum Discussion

L1102's avatar
L1102
Icon for Helper I rankHelper I
8 months ago

Calculating Latest Weeks & Comparing to Same Timeframe PY

Hi All,   Looking for advice, I'm trying create a filter that has lastest week options for the end user on my dashboard ie. (YTD, L4,L12,L52). I have the following dax code to call the lastest time...
L1102's avatar
L1102
Icon for Helper I rankHelper I
8 months ago

d_m_LNK , I hard code the year because my fiscal calendar starts in May and is currently fiscal year 2026, however when I import my data from it's source it has the proper calendar date. For example, my fiscal year has a date range of May 2025 - May 2026. When I calculate YOY changes I needed it to identify what year is current and what was prior year because there is a combination of both 2025 & 2026 in one fiscal year.

 

I've only been doing dax and power bi since september so i'm still very green. If you know a better way to evaluate my years I'm open to all suggestions.

L1102's avatar
L1102
Icon for Helper I rankHelper I
8 months ago

Actually I found a way not to hard code the year... thanks for the tip!!

 

$ Sales CY =
VAR Current_Year = MAX(Promo Calendar'[Year])

RETURN
CALCULATE(sum(Data_Dump_Sheet[$ Sales]), Promo Calendar'[Year] = Current_Year)
  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity Support
    8 months ago

    Hi L1102 ,

    Thank you for sharing the update and confirming that issue has been resolved. If further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

    Best Regards,
    Chaithra E.

    • L1102's avatar
      L1102
      Icon for Helper I rankHelper I
      8 months ago

      Hello v-echaithra , my issue wasn't resolved. d_m_LNK suggested a change in dax on a different measure I had. I still don't have a solution to my original problem.