topic current week vs previous week ? in App Development

current week vs previous week ?

gauravgg — Fri, 25 Mar 2016 11:33:26 GMT

hi,

I want to show current week and previous week bar in bar chart

I wrote the following expression

Current Week : sum({$<Date={'>=$(=Date(WeekStart(Max(Date)),'DD/MM/YYYY'))<=$(=Date(WeekEnd(Max(Date)),'DD/MM/YYYY'))'}>}[Order Value])

Previous Week: sum({$<Date={'>=$(=Date(WeekStart(Max(Date),-1),'DD/MM/YYYY'))<=$(=Date(WeekEnd(Max(Date),-1),'DD/MM/YYYY'))'}>}[Order Value])

but the weekstart() function which i have used starts the week from Sunday to Saturday

I want the week to start from Monday to Sunday

So the expression which i have wrote gives me the wrong output

can anyone help me

thanks in advance

sunny_talwar — Fri, 25 Mar 2016 12:06:59 GMT

Try these:

Current Week : Sum({$<Date={'>=$(=Date(WeekStart(Max(Date), 0, 0),'DD/MM/YYYY'))<=$(=Date(WeekEnd(Max(Date), 0, 0),'DD/MM/YYYY'))'}>}[Order Value])

Previous Week: Sum({$<Date={'>=$(=Date(WeekStart(Max(Date),-1, 0),'DD/MM/YYYY'))<=$(=Date(WeekEnd(Max(Date),-1, 0),'DD/MM/YYYY'))'}>}[Order Value])

gauravgg — Fri, 25 Mar 2016 12:58:43 GMT

Thanks sunny

t_chetirbok — Fri, 25 Mar 2016 13:57:12 GMT

If Sunny answer is correct, please, check it as "Correct Answer"

reddy-s — Mon, 28 Mar 2016 18:30:02 GMT

Hi Gaurav,

Make use of this: inweek(), inweektodate()

Thanks,

Sangram

raviteja475 — Tue, 02 Jul 2019 12:44:09 GMT

i didn't get the answer using inweek() ,inweektodate()