Loading ...

Power BI Days since last customer for a rep | CLEARIFY - Page 1

Public Forums

Posted in: QQube    Microsoft Power BI

Power BI Days since last customer for a rep

Subscribe to RSS
  • nick11
    nick11 Browser
    4/1/2020

    I'm looking for a way to find how many days since a rep had a new job turned in.

    I'm using the Job table, document date table, and vd_JobRep Table. I've tried adding a measure of 

    Measure = LASTDATE('Document Dates'[JobTxn Document Transaction Date].[Date]) to the Job table but it just dispalys the same date. I'm guessing it needs to be grouped by Rep maybe... 

     

  • nick11
    nick11 Browser
    4/2/2020

    I'm using 

    Column = if(Job[JobTimeCreated] = CALCULATE(MAX(Job[JobTimeCreated]),ALLEXCEPT(Job,Job[LinkToSalesRepID])),"True","False") 
    but i get two results for customers who have two estimates. any suggestions? 
  • Freedup1
    Fran Reed Superstar
    4/4/2020
    Answered

    Hey Nick11,

    Without diving too deep into your issue,

      I would think you would want to do a DateAdd measure to count the days from the date showing on your report (or all dates) and the Job created date. And then find the Max for that. It can all be done in one measure.  

     

     

     

     

     

     

Page 1 of 1 (3 items)