Hi,
I am trying this as a calculated column:
=if(CALCULATE(COUNTROWS((Sales)),'Calendar'[Date]>=Sales[start],'Calendar'[Date]<=Sales[end],)>0,1,0)
but I get the subject error message. Sales[start] end [end] are also calculated columns.
Help is appreciated...
Solved! Go to Solution.
Rewrite your code to this:
=if(CALCULATE(COUNTROWS((Sales)),'Calendar'[Date]>=Sales[start],'Calendar'[Date]<=Sales[end])>0,1,0)
I only deleted the last comma in the CALCULATE function call.
Rewrite your code to this:
=if(CALCULATE(COUNTROWS((Sales)),'Calendar'[Date]>=Sales[start],'Calendar'[Date]<=Sales[end])>0,1,0)
I only deleted the last comma in the CALCULATE function call.
Good catch. I need better glasses.
Many thanks
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
123 | |
74 | |
66 | |
53 | |
53 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |