Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Table with extrapolated dates

  Hello, I have been trying to wrap my head around how best to approach this problem.  I have been working on this for a couple days. I have a table with a baselined  list of orders by subgroup. T...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello all,

     

    I was able to solve my problem using a DAX calculation to create a burndown chart. 

    I created a calendar and then added columns for each of the subgroup.  Then I used the DAX expression for each subgroup to count up all open orders on each given day.

     

    Subgroup1 = COUNTROWS(FILTER(tablename,
    (tablename[baseline]=1) &&
     (tablename[action] = "Orderbeingvalidate"  || 
    tablename[action] = "InfulfillmentQueue") &&

    (tablename[last_update] >= 'Backlog Calendar'[Date]) &&
    (tablename[subgroup] = 1)

    ))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

I am not clear about the logic that you use to get the expected table from the sample data in original table. Could you please explain it by taking the first row data of Anticipated table as example ?

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello all,

     

    I was able to solve my problem using a DAX calculation to create a burndown chart. 

    I created a calendar and then added columns for each of the subgroup.  Then I used the DAX expression for each subgroup to count up all open orders on each given day.

     

    Subgroup1 = COUNTROWS(FILTER(tablename,
    (tablename[baseline]=1) &&
     (tablename[action] = "Orderbeingvalidate"  || 
    tablename[action] = "InfulfillmentQueue") &&

    (tablename[last_update] >= 'Backlog Calendar'[Date]) &&
    (tablename[subgroup] = 1)

    ))