Forum Discussion
Matrix: If statement return column
Hi all,
I have the two tables 'Placements (2)' and a date table visualised in the below matrix with the measure:
Instead of the "Yes" is it possible to RETURN the 'Placements(2)'[PayRate] Column?
This would then visualise the figure instead of the "Yes" and would be totalled at the end of the columns.
| CandidateName | PlacementStartDate | PlacementEndDate | Rate1PayRate | Rate1ChargeRate |
| Jayden | 06/07/2020 01:00 | 29/11/2020 00:00 | 21.17 | 31.73 |
| Ian | 01/07/2020 01:00 | 30/09/2020 01:00 | 30 | 33.6 |
| Michael | 07/04/2020 01:00 | |||
| Tim | 07/04/2020 01:00 | 03/05/2020 01:00 | 21 | 25 |
| Nicolae | 06/04/2020 01:00 | 03/05/2020 01:00 | 17 | 18.87 |
| Marius | 06/04/2020 01:00 | 03/05/2020 01:00 | 15 | 16.65 |
| Max | 01/04/2020 01:00 | 27/11/2020 00:00 | 323.75 | 365.84 |
HenryJS ,
Try like
IF(SELECTEDVALUE('Placements (2)'[PlacementStartDate])<= MAX('DaysAndWeeks'[Date]) && SELECTEDVALUE('Placements (2)'[PlacementEndDate]) >= MAX('DaysAndWeeks'[Date]), max('Placements(2)'[PayRate] ),blank())
4 Replies
HenryJS ,
Try like
IF(SELECTEDVALUE('Placements (2)'[PlacementStartDate])<= MAX('DaysAndWeeks'[Date]) && SELECTEDVALUE('Placements (2)'[PlacementEndDate]) >= MAX('DaysAndWeeks'[Date]), max('Placements(2)'[PayRate] ),blank())amitchandak thank you
The Total on the right hand side isn't functioning?
Also it seems to have filtered down the 'CandidateName' to a lesser amount. Is this because if there is no 'Pay Rate' they won't be shown?
Cheers
