Forum Discussion

Aelmelih's avatar
Aelmelih
New Member
3 years ago
Solved

undefined

I need to create a clustered column chart with count of IDs vs time. The issue is I need the ID count aginst 2 different dates sets.

i.e.

count of ID vs Planned date

count of IDs vs actual date

 

How can I do that 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Aelmelih ,

     

    Create a calendar table and create relationships with [Planned date] and [actual date] respectively.

    then please new 2 measures like:

    count of ID vs Planned date = COUNT('Table'[ID])
    count of IDs vs Actual date = CALCULATE(COUNT('Table'[ID]),USERELATIONSHIP('Calendar'[Date],'Table'[Actual date]))

    result:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Aelmelih ,

     

    Create a calendar table and create relationships with [Planned date] and [actual date] respectively.

    then please new 2 measures like:

    count of ID vs Planned date = COUNT('Table'[ID])
    count of IDs vs Actual date = CALCULATE(COUNT('Table'[ID]),USERELATIONSHIP('Calendar'[Date],'Table'[Actual date]))

    result:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum