Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

DAX for rolling average, formula error

I'm trying to calculate the average number of invoices vouchered or the past 5 days, however my DAX returns an error     "Calculation error in measure 'vouchered'[Measure]: a table of multiple val...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I changed it, but I'm still getting an error. Here's my latest function:

    Measure = CALCULATE(
    AVERAGEX(vouchered, COUNT(vouchered[Invoice Number])),
    FILTER(
        ALLEXCEPT(vouchered, vouchered[Created Date].[Date]),
        DATESBETWEEN(
				'vouchered'[Created Date].[Date],
				LASTDATE(vouchered[Created Date].[Date])-5,
				LASTDATE(vouchered[Created Date].[Date])
        )
    )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      hey Anonymous 

       

      try using quick measures to get your past 5 days average.

       

      kind regards;

      HiltonM