Forum Discussion

Taylormade's avatar
Taylormade
Regular Visitor
1 year ago

Count dates with string value

Good Day,

I'm newbie at Power BI hopefully this is a simple question. I have a two tables: Table 1 has last completed dates and second column which has a string value it shows only if your "Current" within 1 yr of training or "Out of Date" outside yr window. Table 2 show name of courses. What I'm looking to get some help with is how to show on matrix report Name course with sum total of how many are current or out of date and drill down to show user and last completed date.

 

 

Thanks for advance help!

 

 

Need Help

6 Replies

  • adudani's avatar
    adudani
    Memorable Member
    1 year ago

    hi Taylormade ,

     

    could you please provide sample input data in a usable format ( table, csv etc) masking sensitive information.

  • Taylormade's avatar
    Taylormade
    Regular Visitor
    1 year ago

     

     

    Thanks for the response. Attach is two sample report, which shows columns and tables related too.  Hopefully this what your looking for.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Taylormade 

       

      Sorry for not being able to fully understand your question. Can you give an example of where your calculations came from with sample data?

       

      Best Regards,

      Community Support Team _Charlotte

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

      • Taylormade's avatar
        Taylormade
        Regular Visitor
        1 year ago

        What I'm looking for is to show training dates at the third level but keep sum total at top level(Org). Also show one attempt per course.

         

        This is the query I was using but with no luck: 

        Column = var _table=SUMMARIZE('User Table Date','User Table'[Training Current],'All Training Responses Main_Final'[User Training Date],"distinctcount",DISTINCTCOUNT('User table'[Training Current]))
        return
        SUMX(_table,[distinctcount])

         

         

         

        Thank you again for taking the time to look over my questions. Hopefully it a little clear this time.