Forum Discussion

NL-Nicolas's avatar
NL-Nicolas
Helper I
4 years ago

NetSales by a date in Column

Hey all!   I have a calculated column here: Last Week = CALCULATE(sum(DayfileSummary[DF_BusinessDay]), FILTER(ALL(DayfileSummary[DF_BusinessDay]),DayfileSummary[DF_BusinessDay]=max(DayfileSummary[...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi NL-Nicolas ,

 

I think you can try code as below to catch the same day one year ago based on [Last Week].

DATE(YEAR(MAX('DayfileSummary'[Last Week])-1 ),MONTH(MAX('DayfileSummary'[Last Week]) ),DAY(MAX('DayfileSummary'[Last Week])))

Please share a sample file without sensitive data with me. This will make it easier for me to find the solution.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

NL-Nicolas's avatar
NL-Nicolas
Helper I
4 years ago

Here is the error I received from that. I also tried 

Last Week Sales = COUNTX(filter(DayfileSummary, DayfileSummary[NetSales]),DayfileSummary[Last Week])
But it returns nothing! Really stumped on this one