Search found 3 matches

by elrcie
Mon Oct 14, 2019 5:41 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 17 - Disconnected Table, p 151
Replies: 1
Views: 2441

Chapter 17 - Disconnected Table, p 151

Hi
When entering the formulas demonstrating Variable Syntax, for some reason that I have tried but have failed to figure our Customers[BirthDate] is not recognized as a column (intellisense does not 'sense' it) and the formula will not work. Has anyone had similar difficulty?
Thanks!
Best,
Louie
by elrcie
Mon Oct 14, 2019 5:37 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Practice Exercise 60
Replies: 2
Views: 463

Re: Practice Exercise 60

Many thanks! Yes, I understand if the purpose was to total sales, calculate would be required. Again, thanks!
by elrcie
Wed Oct 09, 2019 2:48 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Practice Exercise 60
Replies: 2
Views: 463

Practice Exercise 60

Hi
=COUNTROWS(FILTER(Products,[Total Sales]>0 && [Total Sales]<10000))

Seems to work without Calculate. Is there any reason that this is also not an acceptable solution?

Thanks!

Go to advanced search

cron