Forum Discussion

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Custom table - Go live dates vs Today's date

HI

 Help needed to create a custom table. I have the table below. The column CID is the customer number and the CUID is a unique number that identifies one customer at entity level.

Ops Forecast & Actuals column identifies the Go Live Date of the projects.

 

 

What I am trying to achieve is to create 2 columns showing Client name, CUIDS already done (using Today’s date vs Ops Forecast & actual date) and CUIDS pending.

For this customer should be:

  

Done

Pending

Client A

 

5

3

 

I was trying some formulas but not good at DAX.

I was trying to create a filter but not working when using CID. any tip?

 

Projects = DATEDIFF(TODAY(),'Weekly Slippage'[Ops Forecast & Actuals],MONTH)
 
THanks,
 
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    romovaro , not very clear, but you need a column like

     

    if('Weekly Slippage'[Ops Forecast & Actuals] < today() , "Done", "Pending" )

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    romovaro , not very clear, but you need a column like

     

    if('Weekly Slippage'[Ops Forecast & Actuals] < today() , "Done", "Pending" )

    • romovaro's avatar
      romovaro
      Icon for Responsive Resident rankResponsive Resident
      4 years ago

      HI

       

      I might need to do a liitle adjustment.

      Before today, (DONE), after today but before 01/01/2049 (Scheduled) and if Date=01/12/3000 (On Hold)

      Tried a few formulas but getting error. (see one below)

       

      Done_Pending = if('Weekly Slippage'[Ops Forecast & Actuals] < today() , "Done", if(DATESBETWEEN('Weekly Slippage'[Ops Forecast & Actuals], Today(), DATE(2049,1,1)),"Scheduled", if('Weekly Slippage'[Ops Forecast & Actuals] =DATE(3000,12,1), "On Hold" )))

       

       

      • romovaro's avatar
        romovaro
        Icon for Responsive Resident rankResponsive Resident
        4 years ago

        HI amitchandak.

         

        I used your formula to create the first column and then I created a diff column using the filter for my unscheduled otherwise your column and it seems it works. thanks.

         

        D-P = IF('Weekly Slippage'[Ops Forecast & Actuals]>DATE(2049,01,01), "Pending-Unscheduled", 'Weekly Slippage'[Done-Pending])