topic Calculate order reserve for future on each date in DAX Commands and Tips

Calculate order reserve for future on each date

bininja — Wed, 22 Apr 2020 14:52:30 GMT

Hi guys,

I am looking to create a field to show order reserve for the future on each date.

I have got it working by using filters in dax but that does not give me the possibility show it added to a range of dates.

Here is a data sample. I have the first two columns and need to create the third one. I want to mention that the only thing I can use is DAX as the dataset is locked and I cant edit anything.

Re: Calculate order reserve for future on each date

Anonymous — Thu, 23 Apr 2020 14:51:50 GMT

// Calendar joins on Date to Orders[Date] // and is the date table in the model // marked as such. [Order Count] = COUNTROWS( Orders ) [Orders Reserve] = var __firstDateInContext = FIRSTDATE( 'Calendar'[Date] ) // Get the total count of orders // from the first date to the end. var __result = CALCULATE( [Order Count], // For this to work, 'Calendar' must be // marked as the Date table in the model // and has to be a proper date table! 'Calendar'[Date] >= __firstDateInContext ) return __result

Best

Re: Calculate order reserve for future on each date

bininja — Fri, 24 Apr 2020 10:58:21 GMT

Anonymous Hi. Thanks for your reply.

I am getting the following error using this formula:

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value".

Re: Calculate order reserve for future on each date

Anonymous — Fri, 24 Apr 2020 11:23:58 GMT

It works correctly. I've checked it. Something's wrong on your side.

Best
D