Forum Discussion

deanford's avatar
deanford
New Member
8 years ago

Double filter?

Hi All

 

Looking for some help. I'm relatively new to POWER BI and have come stuck in what I'm trying to do.

 

I basically work for a college, and I've been asked if we can track learners who've not attended for the past 3 weeks which I've managed to do and it works brilliantly. 

 

The next thing I'm trying to do, is based on the results, find their last attendance date. 

 

My table currently consists of:

TraineeID - POT - Centre - Scheme - Assessor - STARTDATE - Earliest Week Commencing - Latest Week Commencing

 

With the Week commencing columns, it basically shows the date range that's been searched for that specific learner, where 'learning hours' = 0

 

I'm trying to create another table, that shows possibly the same traineeID and POT, returning the latest week commencing where learning hours > 0

 

Does that make sense at all?

 

Thanks in advance for the help!

 

Much appreciated

Need Help

4 Replies

    • deanford's avatar
      deanford
      New Member
      8 years ago

      Hi v-chuncz-msft

       

      Thanks for getting back to me.

       

      How would I share a complete example sorry? I'm currently using directquery 

       

      Cheers

      Dean

      • deanford's avatar
        deanford
        New Member
        8 years ago

         

        So basically, the top table displays learners who've not attended in the last 3 weeks, where learning hours are zero. 

        The second table is a breakdown of the learning hours for learners, but I don't want this, what I want is basically to show the date circled in red, because that is the last date where learning hours are assigned.

         

        Hope that makes a bit more sense.

         

        Thanks

        Dean