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