Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated Column Last work day

Hi All,   I want to pull out the transaction for any vehicle on a given report based on previous workday for a selected week  ( monday to sunday) In this instance last work day would be 1st Oct, b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Thanks for helping.

Please find the report attach. cheeers

 

Report

dax's avatar
dax
Community Support
6 years ago

Hi vinc,

I didn't find LastLocation in your sample, please  check it and inform me more detailed information(such as your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

    is the one i have problem with.

    calculate firstnonblank for the Day = CALCULATE([Firstnonblank job or location],FILTER(PlantGPS,PlantGPS[Date]=[PreviousWorkday]))

     
    I expect when previousWorkday = PlantGPS Date then use PlantGPS data if not then return LocationReport[Address])
     
    But now when PlantGPS(date) <>Previousworkday, it will use the previous day of Previousworkday (ie if previous workday is 6/10/2019 and no PlantGPSdate = 6/10/2019, it will use 5/10/2019).
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Zoe,

     

    can  you please assist ?

     

    thanks