Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
In the formula below, what does the pipe character (|) stand for? Sales $ - Beer = CALCULATE([Sales $],Categories[Category]="Draft Beer"||Categories[Category]="Burgers")
Or
And
Else
Don’t know
2
Advanced
Assume that you have stored your Product ID numbers as text, and want to write a CALCULATE() function to return product 54698 only. Which version of the function will work?
Result = CALCULATE([Sales Units],Products[Product ID]=54698)
Result = CALCULATE([Sales Units],Products[Product ID]="54698")
Result = CALCULATE([Sales Units],Products[Product ID]='54698')
Don’t know
3
Advanced
The image below was snapped from a single page on a report. The bar chart uses a formula that generates as follows: Sales = SUM(Transactions[Amount]). What is the formula used to generate the $1.4m showing in the yellow box?
=CALCULATE([Sales],Categories[Category]="Draft Beer")
=CALCULATE([Sales],Categories[Category]="Wine")
=CALCULATE([Sales],Categories="Draft Beer")
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement