Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How do i get Inflow and Outflow count

Hi  I have requirement that, in a table we have capturing requests made by user so in Request Id column ids will create and in status column status of the rquests like Assigned,pending,completed etc...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI Anonymous,

     

    You can try to use below formula calculate the inflow and outflow count:

     

    Prerequisite: you need a calendar table as the axis.

     

    Inflow Count = COUNTX(FILTER(ALLSELECTED(Records),[SubmitDateTime]<=MAX('CALENDAR'[Date])&&[CompletedDateTime]>MAX('CALENDAR'[Date])),[ID])

Outflow Count = COUNTX(FILTER(ALLSELECTED(Records),[SubmitDateTime]>MAX('CALENDAR'[Date])||[CompletedDateTime]<MAX('CALENDAR'[Date])),[ID])

     

     

    Regards,

    Xiaoxin Sheng

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

Anonymous its very difficult to read and easily understand what you are asking

 

please provide a table of the information with an example of what you want.

 

ta

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi vanessafvg

     

    Below screenshot is my requirement and i have mentioned the Data link below.

                

    Data

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous,


      Can you please share some sample date test? I have can't open your sharepoint link.

       

      Regards,
      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi

         

        I can Able to load only screenshoot