topic Re: Creating a Count measurement with date filter in DAX Commands and Tips

Creating a Count measurement with date filter

U-ALE — Tue, 28 Feb 2023 11:32:25 GMT

Hey, first time posting here.

I'm trying to create a measurement of sold units during a certain time period without having a visual filter.

Count SR with date = CALCULATE(COUNT (base'[SerialNumber]), DATESBETWEEN(([Sold Date], DATE(2021,04,01), DATE(2022,05,31))))

I can't get it to work.. The error I get is "Operator or expression '( )' is not supported in this context."

Appreciate all help!

Re: Creating a Count measurement with date filter

JMarv — Tue, 28 Feb 2023 11:42:06 GMT

Try:

Count SR with date = CALCULATE(COUNT(base'[SerialNumber]), DATESBETWEEN(base'[Sold Date], DATE(2021,04,01), DATE(2022,05,31)))

The main issue with the original formula was the extra set of parentheses around the first argument of the DATESBETWEEN function. The correct syntax is to only include the column reference base'[Sold Date] as the first argument of DATESBETWEEN.

Re: Creating a Count measurement with date filter

U-ALE — Tue, 28 Feb 2023 11:44:59 GMT

Thanks,

Such a easy fix.. Feels like I tried everything..