Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The following DAX code is correct and accepted in Power BI, but IntelliSense marks it as syntax error after the first argument:
Subscription =
ALLNOBLANKROW ( Subscriptions[First List], Subscriptions[Cancel Type], Subscriptions[Status], Subscriptions[StatusCode], Subscriptions[SubscriptionStateKey] )
It seems the ALLNOBLANKROW syntax is not correct in the IntelliSense parser.
Solved! Go to Solution.
Thanks for catching this Marco! Sorry about that :). Turns out the implementation of ALLNOBLANKROW didn't match the original spec when the update to intellisense ships we'll fix the MSDN documentation to include the extra parameter(s) as well
Thanks for catching this Marco! Sorry about that :). Turns out the implementation of ALLNOBLANKROW didn't match the original spec when the update to intellisense ships we'll fix the MSDN documentation to include the extra parameter(s) as well
The fix will be hopefully available in Sep 2017 version of Power BI Desktop. If not, it will be fixed in Oct 2017 version of Power BI Desktop.
Best Regards,
Herbert
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |