Forum Discussion

One-Dash's avatar
One-Dash
Frequent Visitor
4 years ago

calculating column from other columns

Hello! 

I'm trying to create a visual that shows amount/count  of IDs left at the end of each day that were not QCed

here is the sample table below.    have this table related with Date table using the Date column

what i'm hoping to do is ...

For each day ,  i want to see how many ID's are left that are not QCed.  the  starting number  is going to be 25  since we have that many in backlog not QCed .....in other words I'm hoping to make the column show what ever is left  (25) + received - QC for every day . .  .    any suggestion is appreciated. Thanks

DateIDReceived DateQC Date???
1/1/2022DY123451/1/20221/1/202225
1/2/2022DY123461/1/20221/1/2022 
1/3/2022DY123471/1/20221/2/2022 
1/4/2022DY123481/2/20221/2/2022 
1/5/2022DY123491/3/20221/3/2022 
1/6/2022DY123501/3/20221/4/2022 
1/7/2022DY123511/3/20221/7/2022 
1/8/2022DY123521/3/20221/8/2022 
1/9/2022DY123531/4/20221/9/2022 
1/10/2022DY123541/4/20221/9/2022 
1/11/2022DY123551/4/20221/10/2022 
1/12/2022DY123561/4/20221/11/2022 
1/13/2022DY123571/4/20221/12/2022 
1/14/2022DY123581/4/20221/13/2022 
1/15/2022DY123591/5/20221/14/2022 
1/16/2022DY123601/5/20221/15/2022 
Calculated columns
DAX
Help appreciated

6 Replies

  • vapid128's avatar
    vapid128
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

     

    Table22 = GENERATE(Table11,GENERATESERIES(int(Table11[Received Date]),int(Table11[QC Date])-1))
    • One-Dash's avatar
      One-Dash
      Frequent Visitor
      4 years ago

      what is the value column doing?  i did the visual and it shows the id count going down when in reality i know they  have actually stayed high 

       

  • vapid128's avatar
    vapid128
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

    Value is the date.

    And your data is going down,

    Is it because you have many line with no  QC Date?

     

    • One-Dash's avatar
      One-Dash
      Frequent Visitor
      4 years ago

      yes, i have a lot of entries with no QC date , since lot of them have not been QCed.  but that's what i want to capture. .. that is  "how may count of IDs i have for each date that have not been QCed".  as each day goes by i should have lot more because i will get what ever is rolled over from the previous date.  thanks 

      • vapid128's avatar
        vapid128
        Icon for Solution Specialist rankSolution Specialist
        4 years ago

        add colnum:

        new QC date =

        if([QC date] >0,[QC date],TODAY())

         

        Table22 = GENERATE(Table11,GENERATESERIES(int(Table11[Received Date]),int(Table11[new QC Date])-1))