Forum Discussion

Victormar's avatar
Victormar
Helper V
3 years ago
Solved

Generate in between dates for bugs

Helo community,

 

I am trying to plot the number of bugs from Jira over time, and I would like to show the same bug between created date and resolution date.

I had successfully created a table with one column containing the ID of the bug, and another column with the dates between. I am not sure is the best option, I am open to suggestions.

 

The problem comes when I try to link the tables using the ID, I get the circular dependency, and I don't quite understand how to adapt de code, I understand it is related to the blank row? According to the SQL BI?

https://www.sqlbi.com/articles/understanding-circular-dependencies/

 

My code:

Bug Days =
    SELECTCOLUMNS(  
        GENERATE(
            'Jira - Main',
            DATESBETWEEN(
                'DIM_Calendar'[Date],
                    'Jira - Main'[Created Day],
                    'Jira - Main'[Resolution Day])
                ),
        "ID",'Jira - Main'[id],
        "Bug Dates",[Date] 
        )
 
Thanks in advance, much appreciated! 😄
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Victormar , I tried a code like this in past, see if this can help

    Expanded = GENERATE(Data,CALENDAR(Data[Start date],Data[End date]))

     

    where data is my table having Start and end date.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Victormar , I tried a code like this in past, see if this can help

    Expanded = GENERATE(Data,CALENDAR(Data[Start date],Data[End date]))

     

    where data is my table having Start and end date.

    • Victormar's avatar
      Victormar
      Helper V
      3 years ago

      That worked pretty good! Many thanks 🙂