Forum Discussion

Icon for Advocate I rank

Advocate 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...

Icon for Advocate I rank

Advocate I

8 years ago

Anonymous

Not applicable

8 years ago

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
Advocate 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
  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
  - aarikc17
    Advocate I
    8 years ago
    Anonymous
    
    I am trying to count the rows of the previous day, this is where I'm at so far.
    
    Scheduled Starts Yesterday = CALCULATE(COUNTROWS(Table 1),MAXX(FILTER(ALL(Table1),TODAY()<MAX(Table1[SCH_STRT_DT])),TODAY() && Table1[SECT_NO]="1234" && Table1[SLS_MDL]<>"18C" && PKG_ORD[SLS_MDL]<>"9C" && Table1[SLS_MDL]<>"12C"))
    
    But I am getting the error "Maxx has been used in a True/False expression that is used as a table tilter expression, This is not allowed"

Related content