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!
     
JosefPrakljacic's avatar
JosefPrakljacic
Icon for Solution Sage rankSolution Sage
6 years ago

Hey XaviOV,

 

here is an explanation video how to solve your problem. 

I could also just write the Measure, but I think it would be better if there was a solid explanation and Curbal is just good at it 🙂

 

Please don't forget to give a 👍 and accept the post as solution. (If it helped 😅)
Have a nice day!

BR,
Josef
Graz - Austria