Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |