Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Compare values per date

Hi guys, I need your help.

I need to compare the value between the dates in the columns

In short, I need to create a measure that is the date column value compared 7 days ago.

Help me?


Need Help
Tutorial Requests

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous you can wwrite a measure like below:

     

    Value 7 days ago = 
CALCULATE( [Your measure you want to compare], 
DATEADD( Calendar[Date], -7, DAY ) 
)

    Assuming you have date/calendar dimension in your model, if not then you need to add one which is easy and there are many post on this topic.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Não deu certo,


      Ele não é efetivo

      =/

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Eu precisava comparar baseado nas colunas de data que vão sendo acrescentadas todos os dias.

        então as contas são D-1 - D-2, D-1 - D-7
        Isso tudo de forma dinâmica, do jeito que , o dia 07/09 compara com 01/09, dia 06/09 compara com 31/08..

        e por ai vai.