Forum Discussion
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 wi...
Uzi2019
Community Champion
Community ChampionHi 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!