Forum Discussion

shubhamone8's avatar
shubhamone8
New Member
2 years ago

Get data for a week before considering TODAY()

Hello People,
I am working on a dataset wherein I have Date, Category, Client Name, & Values as Columns,
Date is upto January to December, & i have added Week name column in this to get the week wise bifurcation, Values is updated once weekly, I want to search  previous week, everyday and in which day the data is loaded , I want previous week that day data from today to be fetched.

I.e. Today is 04/04/2024 then my dataset will be having date from all 7 days but data will be present only in 1 day.

could anyone give me some advice on the way to do that in power query/ dax measure?

Thanks !!!

Need Help

1 Reply

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi shubhamone8 

    try this below dax. 

     

     

    lastupdated =
    var A= WEEKNUM(TODAY())
    var b= CALCULATE(SUM(Cat[Values]), FILTER(Cat, MAX(Cat[Weel])=A))
    Return b
     
     I hope this would resolves your issue!