Forum Discussion

XaviOV's avatar
XaviOV
Icon for Helper V rankHelper V
6 years ago
Solved

Graphic values last week and current week

Hi there, I created a "Clustered column chart" and put the values ​​with relative filter for this week, but I would like to insert the values ​​for the last week. How can you do it?   For look...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  XaviOV ,

     

    Your measure needs to be modified as below:

     

    Con_fil_ene_act -1semana producción = 
        CALCULATE(
SUM('Electricidad'[Con_fil_ene_act Producción]);
            DATEADD('Electricidad'[Fecha]; -7; DAY)
)

     

    While using time intelligence function,you'd better not add .[date].

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
     
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi  XaviOV ,

 

Your measure needs to be modified as below:

 

Con_fil_ene_act -1semana producción = 
        CALCULATE(
SUM('Electricidad'[Con_fil_ene_act Producción]);
            DATEADD('Electricidad'[Fecha]; -7; DAY)
)

 

While using time intelligence function,you'd better not add .[date].

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!