Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have data as below ,with this data i want to create a weekly report to show data of 7 days in a week
I need data to show only from 20231201 to 20231207 , can you help me with this
I need to show the complete details of the previous week , not sum or count,can you help me
@Luffy20 Perhaps this way? But still not sure where you are trying this 🙂
If(Date(Date)>=Date(Max(Date-14)) and Date(Date)<=Date(Max(Date-7))
I had two weeks of data , i need to show only one week data without filtering
Hi @Luffy20 ,
You want to show only one week data without filtering, So where you want to know
like in any Table or any other visual
or when loading data itself restricting data to one week
Please clarify Where you want to show data
Thanks!!!
In a Table
hi @Luffy20 ,
I think your requirement like this below
Below is the expression:
=if([Order Date] >= Max(total [Order Date]) - 6 AND [Order Date] <= Max(total [Order Date]), [Order Date])
Hope it works for you!!
Thanks!!!