monday to monday

[Anonymous]

hii i ave a slicer which display week no from monday to sunday

but my requirement is slicer should take monday to monday 12:00 to 12:00 which is a full complete week

how can i do it

https://drive.google.com/file/d/1ySauhYpsWJ7BfmbOxOzqTJ727v7y6bQp/view?usp=sharing

[Fowmy]

@Anonymous 

What do you mean by Monday to Monday? then it will be 8 days and the calendar overlaps.
You have a slicer for Week Number which represents a complete 7 days work. Can you explain what exactly is the requirement?

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

in my data The filtering is doing Sunday to Sunday 

where my report should be Monday - Monday so basically When it should be from Monday morning through Sunday night

[Fowmy]

@Anonymous 

Yout Table is already built based on Monday through Sunday, I think it works as per your requirement. That number 2 there sets the day and week Monday to Sunday

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

hiii fomi

i too have checked that but when i am filtering it is showing as sunday to saturday i have cross checked the values with other

can you help me to create a offset for day

i think it will solve my problem with offset 1 day

[Fowmy]

@Anonymous 

Share a screenshot of where it filters from Sunday to Saturday?

It could be a measure problem 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@Anonymous , yet to check your file. But you need to have some like. Assuming week is selected in the slicer from Date Table

//connected date table

Measure =
var _min = minx(Date, Date[Date]) + time(12,0,0)
var _max = maxx(Date, Date[Date]) + time(12,0,0)
return
calculate([measure],filter(Table, Table[Date]>=_max && Table[Date]<=_min) , all(Date))

//disconnected date table

Measure =
var _min = minx(Date, Date[Date]) + time(12,0,0)
var _max = maxx(Date, Date[Date]) + time(12,0,0)
return
calculate([measure],filter(Table, Table[Date]>=_max && Table[Date]<=_min) ))

[Anonymous]

hiii amit i tried to create the measure but it didnt work

can you plz check my data and help me with a solution