Forum Discussion

aarikc17's avatar
aarikc17
Icon for Advocate I rankAdvocate I
8 years ago

Previous INPUTED Date Count

I am trying to count the rows in a table that contain the previous INPUTED date (sometimes there are weekend dates, and sometimes there isn't).   A normal previous date function would work for Tues...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi aarikc17,

 

Please provide more detailed information to help use clarify your requirement.
For instance:
Sample data, screenshots, calculate steps,...

 

Regards,

Xiaoxin Sheng

aarikc17's avatar
aarikc17
Icon for Advocate I rankAdvocate I
8 years ago

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi aarikc17,

     

    For your scenario, I think you can try to find out the last date, then use it to filter and calculate the related records.

    Sample measure= 
var checkdate=Today()
var last_date=MAXX(FILTER(ALL('Table'),[Date]<checkdate),[Date])
return
COUNTROWS(FILTER(ALL('Table'),[Date]=last_date))

     

    Regards,

    Xiaoxin sheng

     

    • aarikc17's avatar
      aarikc17
      Icon for Advocate I rankAdvocate I
      8 years ago

      Anonymous

       

      Manually filtering a date for multiple tiles is not an option. I need to "hard code" the previous dates from production.

       

      I would think it would be easier to tell MS BI to "Look at today, and find the first previous date"

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI aarikc17,

         

        My formula can used to find out the last previous date of current date.(it also works on discontinuous date range)

        Comment: find out smaller date than current date, then get the max one of them.

        Measure:

        Previous Date = MAXX(FILTER(ALL(Sheet4),[Date]<MAX(Sheet4[Date])),[Date])

         

         

        Regards,

        Xiaoxin Sheng