## Search found 6 matches

Thu Nov 26, 2020 4:00 pm
Forum: Power Query
Topic: Subtract time with offset
Replies: 1
Views: 1300

### Re: Subtract time with offset

Hi Ross,
Are there just two requisition times, Row 1 & 5, and then rows 2-4 need to compare time elapsed since row 1, and 6-10 needs to compare time elapsed since row 5?
Thu Nov 26, 2020 3:43 pm
Forum: PowerPivot/DAX
Topic: If multiplication
Replies: 2
Views: 376

### Re: If multiplication

Hi Yoshi, A tricky little problem you have there. I believe this formula should resolve your challenge: =SUMX(Inventory, VAR RawCalc = RELATED(ItemMaster[Selling Price]) * Inventory[QTY] // this gives us our Extended Amount VAR TaxDisc = if(Inventory[Tax]="Tax",RawCalc/1.1) // If Tax has b...
Wed May 06, 2020 3:52 pm
Forum: PowerPivot/DAX
Topic: Calculating recurring customers on a rolling basis
Replies: 3
Views: 749

### 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...
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: 638

### 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...
Fri Mar 06, 2020 9:20 am
Forum: General
Topic: Data Modeling Issue? [Solved]
Replies: 3
Views: 10343

### 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...
Thu Mar 05, 2020 4:00 pm
Forum: PowerPivot/DAX
Topic: Showing results of the highest slicer selection.
Replies: 1
Views: 522

### 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...