Hello again,
I've posted a couple of queries today DAX - How to use a Column Value to use in a Measure and DAX - Joining Tables and Measures and am close to finalising a report - I'd appreceiate some help with my next step.
I now have a table like the below. I would like to calculate Table.Number * Measure.Day % x to give the results in the 'Help Please' column.
Please can someone help me with a query to identify those row values in the Table.Number column?
| Table.Date | Table.Salesperson | Table.$ Amount | Table.Number | Measure.Total | Measure.Day % | Help Please |
| 1st Feb | Bob | 200 | 1 | 1000 | 20% | 0.2 |
| 1st Feb | Jessica | 200 | 1 | 1200 | 17% | 0.166666667 |
| 2nd Feb | Bob | 300 | 2 | 1000 | 30% | 0.6 |
| 2nd Feb | Jessica | 400 | 2 | 1200 | 33% | 0.666666667 |
| 3rd Feb | Bob | 500 | 3 | 1000 | 50% | 1.5 |
| 3rd Feb | Jessica | 600 | 3 | 1200 | 50% | 1.5 |
Many thanks
Gritman
