Forum Discussion

L1102's avatar
L1102
Icon for Helper I rankHelper I
10 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
10 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
10 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
    10 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.