Search found 4 matches

by Jason Cockington
Wed May 06, 2020 3:52 pm
Forum: PowerPivot/DAX
Topic: Calculating recurring customers on a rolling basis
Replies: 3
Views: 337

Re: Calculating recurring customers on a rolling basis

Hi Eriha591, This was an interesting question, and I quite enjoyed developing a solution for you. I have used our sample Adventure Works database to develop a proof of concept workbook. When you are faced with a challenge like this, i always recommend breaking the problem into bite sized pieces. Thi...
by Jason Cockington
Wed Apr 29, 2020 7:58 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Matrix shown bottom p38, topic 13
Replies: 1
Views: 201

Re: Matrix shown bottom p38, topic 13

Hi Korndorb, A matrix in Power BI applies filters on your data by the values represented in the rows. So, when you look at the first row of the matrix, your Customers table gets filtered for YearlyIncome = 10,000, then your Count of Occupation runs a DISTINCTCOUNT on the filtered table, resulting in...
by Jason Cockington
Fri Mar 06, 2020 9:20 am
Forum: General
Topic: Data Modeling Issue? [Solved]
Replies: 2
Views: 1731

Re: Data Modeling Issue? [Solved]

Hi Dee, My recommendation would be: - You definitely need a primary key in your Job Hours table that can link to the same key in your Timecard table, so that you can filter your Timecard data by Job Hours. - create a unique ID for your Job's (concatenate Job # with the first (number) part of Job Cod...
by Jason Cockington
Thu Mar 05, 2020 4:00 pm
Forum: PowerPivot/DAX
Topic: Showing results of the highest slicer selection.
Replies: 1
Views: 245

Re: Showing results of the highest slicer selection.

Hi SRN, If I understand your question correctly, you are just trying to see the maximum value when multiple values are selected in the slicer. So when month 2, 3 & 4 are all selected the only value that shows is the largest value in the selection. If this is the case, then you can simply right c...

Go to advanced search