Search found 6 matches

by Jason Cockington
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,
I am trying to understand your problem, but your description doesn't match your sample data.
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?
by Jason Cockington
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...
by Jason Cockington
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...
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: 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...
by Jason Cockington
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...
by Jason Cockington
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...

Go to advanced search

cron