Forum Discussion
Solved
Assigning Values based on conditions
Hi All, I am looking to reassign a value based on specific conditions, here is my table below... Name Amount Delivery Day A 1 Blank A 2 Day 1 A 1 Day 1 A 5 Day 2 B...
hi Ttaylor9870
try to plot a table visual with Name column and two measures like:
AmountSum = SUM(TableName[Amount]) MaxDeliveryDate = MINX( FILTER( TableName, TableName[Amount]=MAX(TableName[Amount]) ), TableName[Delivery Day] )it worked like:
Hi FreemanZ,
How would this then look if you were to change it to No of rows opposed to Amount?
Name Amount Delivery Day A 1 Blank A 2 Day 1 A 1 Day 1 A 5 Day 2 B 4 Day5 B 5 Blank B 8 Day 2 B 12 Day2 C 7 Day 3 C 8 Day 1 C 17 Day5 C 1 Day 1 Company Amount Delivery Day A 9 Day 1 B 29 Day 2 C 33 Day 1
Hi FreemanZ,
How would this then look if you were to change it to No of rows opposed to Amount?
| Name | Amount | Delivery Day |
| A | 1 | Blank |
| A | 2 | Day 1 |
| A | 1 | Day 1 |
| A | 5 | Day 2 |
| B | 4 | Day5 |
| B | 5 | Blank |
| B | 8 | Day 2 |
| B | 12 | Day2 |
| C | 7 | Day 3 |
| C | 8 | Day 1 |
| C | 17 | Day5 |
| C | 1 | Day 1 |
| Company | Amount | Delivery Day |
| A | 9 | Day 1 |
| B | 29 | Day 2 |
| C | 33 | Day 1 |
hi Ttaylor9870
what do you mean by No of rows opposed to Amount?
Hi FreemanZ ,
No of Delivery Day rows, for example in the table above Compnay A had 2 Delivery Day 1 so make a new column that then assigns Company A to Delivery day 1.
Many Thanks for your help! 😊