Browsed by
Author: Tim Beard

How I got to grips with table calculations

How I got to grips with table calculations

There’s a great mystique around the whole area of table calculations with LODs having stole a lot of their limelight. They range from very simple to incredibly difficult to get your head around. I’m still at the beginning of my discovery, but I wanted to share a tip about how some of the basic concepts started to find purchase on my neurons. I simply created the table below from the Superstore dataset, added SUM(Sales) to the table and used the…

Read More Read More

WOW2020 Week 19: Can you build a dynamic date drilling chart?

WOW2020 Week 19: Can you build a dynamic date drilling chart?

This week’s Workout Wednesday Challenge was about creating a dynamic visual drilldown of a line chart. It should automatically change from a week view to a day view on selecting a range of dates. Challenge by Ann Ann’s solution on public My solution on public My Solution: Summary Create parameter and filter to limit range of the full data set, initially set to 52 weeks Create a custom date from [Order Date] based on continuous week in order to create…

Read More Read More