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...
Calculated columns
DAX
Help appreciated
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))

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

      I tried that one,  the count didn't do down like the firts one,   but the numbers are still slightly higher than what's in my Data.  the last date entry in the visual for example has 541,  but that number should have been 395.  maybe i'm missing some filters i need to apply.