topic Re: Slicer weekly in DAX Commands and Tips

Slicer weekly

Anonymous — Mon, 10 Feb 2020 02:33:01 GMT

Hello, everybody,

I created weekly coin sales and showing this week and previous week coin sales. Now to see both week, we need to click two weeks in a slicer part.

But my customer wants to click just once on a filter choosing just one week, previous week appear automatically.

Is there any method to click just one and see with previous week cooin sales as well?

Thank you always.

Re: Slicer weekly

Anonymous — Mon, 10 Feb 2020 02:42:12 GMT

Make a disconnected date table and use it in slicer.
Create weeknum column in your main table and date table.
And then create two seperate measures of this week and previous week and use it in your table visual.

This week sales count=Calculate(count([table,[col]),filter(table,table[weeknum]= min(date[weeknum])))
Similarly create for previous week by simply adding -1 at the end.

Thanks
Pravin

Re: Slicer weekly

Anonymous — Mon, 10 Feb 2020 04:25:04 GMT

hi Anonymous ,

Please use the below Dax formula to make new MEASURE to calculate last week sale.

lastWeek_Sales = VAR WeekNum_LastWeek = WEEKNUM ( TODAY () ) - 1 RETURN CALCULATE ( SUM ( 'table'[Sale] ), WEEKNUM ( 'Table'[Date] ) = WeekNum_LastWeek )

You can use this measure too show last week count when this week filter is selected.

do not hesitate to give a kudo to useful posts and mark solutions as solution.

Regards,

Gaurav Raj Singh

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/