Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

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:   Timesheet Y/N = IF(SELECTEDVALUE('Placements (2)'[PlacementStartDate])<= MAX...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    HenryJS ,

    Try like


    IF(SELECTEDVALUE('Placements (2)'[PlacementStartDate])<= MAX('DaysAndWeeks'[Date]) && SELECTEDVALUE('Placements (2)'[PlacementEndDate]) >= MAX('DaysAndWeeks'[Date]), max('Placements(2)'[PayRate] ),blank())

amitchandak's avatar
amitchandak
Super User
6 years ago

HenryJS ,

Try like


IF(SELECTEDVALUE('Placements (2)'[PlacementStartDate])<= MAX('DaysAndWeeks'[Date]) && SELECTEDVALUE('Placements (2)'[PlacementEndDate]) >= MAX('DaysAndWeeks'[Date]), max('Placements(2)'[PayRate] ),blank())

  • HenryJS's avatar
    HenryJS
    Post Prodigy
    6 years ago

    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

     

     

     

      • HenryJS's avatar
        HenryJS
        Post Prodigy
        6 years ago

        Hi amitchandak 

         

        Thanks for your help so far - that's worked.

         

        I am now having issues with the 'Total' on the rows.

         

        It is not Totalling correctly where I have put two x's.

         

        The grand total is maxxing out at 1,400,000 and the sub totals are only showing max not the actualy total.

         

        Can privately share data if you would like?

         

        Thanks