Forum Discussion
Slicer weekly
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 clic...
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
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