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...
d_m_LNK's avatar
d_m_LNK
Icon for Super User rankSuper User
8 months ago

Are you applying this measure as a filter of a visual right now or how are you trying to apply this code?  It looks like you could create this as a calculated table within your model to then use with visuals and measures but you would need to build relationships to your fact with this.  You would also need to reference these dates in your measures as I don't know of a way to get around that.  

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

    Hi d_m_LNK , I'm trying have it available for the end user as a slicer, so instead of going in and clicking all the weeks they want to evaluate, insteadt they have the options to choose to evaluate YTD, L4, L52 etc. The end goal is once they choose L4, all my charts and measures calculate/update visual to L4 weeks vs L4 week same timeframe last year.

    Right now I have the latest weeks being called with the DAX I have, but my measure that are caluclating CY & PY are by filtering on the year. I have a feeling this is where I'm getting stuck with my measure calculations. Looking to see if there is a work around for this, or do i need to create all new measures for this?