Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Reference a previous month using variables in DAX using slicers

  Hi I am trying to reference the last week using some dax code that Greg_Deckler provided.  I got the last week working but it only works after the firstr week in a given month.  How would I ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi vanessafvg

 

It is going of week number not months or last year.  I understand that when you use these it generates a table and I think it is due to table being constrained the month selected but for this purpose I need to sort of see if it is in the previous month and use that.

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous you can probably use use datedd with a filter

 

for example

 

CALCULATE (
    SUM ( 'Table'[Sales Amount] ),
    FILTER ('Table', 'Table'[Date] ) = DATEADD ( 'Table'[Date], -7, DAY )

CALCULATE (
    SUM ( 'Table'[Sales Amount] ),
    FILTER ('Table', 'Table'[Date] ) = DATEADD ( 'Table'[Date], -1, WEEK)

 

haven't test this this though 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    vanessafvg

     

    There is no week unfortunalty, only day/month/quarter/year, if we do -7

     

    Something like 

     

     

    internetTargets[weeknum]= WEEKNUM((DATEADD ( 'Calendar$'[Date], -7, DAY ))))

     

    It does not allow you to use dateadd in a filter expression

     

    FILTER ('Table', 'Table'[Date] ) = DATEADD ( 'Table'[Date], -7, DAY )

     

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago
      FILTER ('Table', 'Table'[Date] = DATEADD ( 'Table'[Date], -7, DAY ))

       you have a comma /bracket in the wrong place

       

      this is how i would do it

      CALCULATE(sum(internettarget), filter('Date', 'Date'[Date] = dateadd('Date'[Date], - 7, DAY)))

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Vanessa,

         

        I am trying to get the full previous week rather than just one day

         

        Thanks for helping though...much appreciated.

         

        Chris