Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Measure dealing with date

Hi,   I am currently working on a dashboard and was wondering if someone could help with a fomula. So a brief explanation of what I want to do is have a slicer where I can select a week on the cale...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

I've made a test for your reference:

1\My data sorcue(Sheet1)

2\Create a caculate table

Calendar = CALENDAR(DATE(2024,1,1),DATE(2024,12,31))

3\Add a measure for sheet1

FilterOnData = If(SELECTEDVALUE(Sheet1[Date])<=  MIN('Calendar'[Date])-1 && SELECTEDVALUE(Sheet1[Date]) >=  MIN('Calendar'[Date])-8,1,0)

4\Add a silder

5\Add a table and filter on the measure

 

Best Regards,

Bof