Forum Discussion

EnSe's avatar
EnSe
Regular Visitor
1 year ago
Solved

Count rows based on date condition from another table

Hello @ all,   I'm just about to build a report in powerBI for a Jira Project-Reporting. For this I want to display a burndown chart showing the burndown of tasks starting from the project start-da...
Need Help
Tutorial Requests
  • johnt75's avatar
    johnt75
    1 year ago

    Make sure that there is no relationship between the date table and the issues table and then you can create a measure like

    Burn Down =
VAR MaxDate =
    MAX ( 'Date'[Date] )
VAR Result =
    CALCULATE (
        COUNTROWS ( 'Issues' ),
        'Issues'[Resolution Date] IN { BLANK (), MaxDate }
    )
RETURN
    Result
v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi EnSe,

 

Thank you for reaching out to Microsoft Fabric Community.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user for the issue worked? or let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi EnSe,

 

Thank you for reaching out to Microsoft Fabric Community.

 

We wanted to kindly follow up to check if the solution provided by the super user for the issue worked.
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi EnSe,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user for the issue worked. If the issue is resolved, please mark the solution as Accept as solution to help the other members of the community find it more quickly. Don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you for being a part of the Microsoft Fabric Community Forum!

     

    Regards,

    Anjan Kumar Chippa