Search found 70 matches

by RamanaV
Thu May 06, 2021 9:42 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Adventure Works database download
Replies: 1
Views: 256

Re: Adventure Works database download

Hi,

The Excel spreadsheets contain the same data as in Access database. You can find this information in Readme - Adventure Works.txt file that is part of the download.
If you want Access database, you can get it from https://xbi.com.au/accessdb
by RamanaV
Wed Apr 07, 2021 11:54 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Combine IF, HASONEVALUE and Value functions query page. 107
Replies: 6
Views: 365

Re: Combine IF, HASONEVALUE and Value functions query page. 107

Please put it in the website enquiry form. We will address it
by RamanaV
Wed Apr 07, 2021 10:58 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Combine IF, HASONEVALUE and Value functions query page. 107
Replies: 6
Views: 365

Re: Combine IF, HASONEVALUE and Value functions query page. 107

Can you please take a snapshot of the formula in formula bar along with the error?
by RamanaV
Wed Apr 07, 2021 10:12 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Combine IF, HASONEVALUE and Value functions query page. 107
Replies: 6
Views: 365

Re: Combine IF, HASONEVALUE and Value functions query page. 107

Please check what you typed - (Products[ProductName})
You typed a curly brace and it did not work I think
It should have been (Products[ProductName])
by RamanaV
Thu Mar 25, 2021 8:45 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Answer Practice Exercise 24 half year column page 74
Replies: 2
Views: 142

Re: Answer Practice Exercise 24 half year column page 74

Hi Cindy, The syntax for the OR function is IF(Condition, result1, result2) and you will read it as if condition is met then the result is result1 else (i.e. condition is not met) result is result 2 . So, IF(OR('Calendar'[CalendarQuarter]=1, 'Calendar'[CalendarQuarter]=2), "H1","H2&qu...
by RamanaV
Mon Nov 09, 2020 5:36 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 18 Multiple Fact Tables
Replies: 6
Views: 2622

Re: Chapter 18 Multiple Fact Tables

The purpose of the example is how to report based on 2 data (fact) tables. We need to have common lookup tables for both fact tables in order to create such a report. The BudgetPeriod (Lookup) table is connected to Budget table The BudgetPeriod table is connected to Calendar table which in turn is c...
by RamanaV
Sun Nov 08, 2020 8:50 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 17 - Disconnected Tables / What-if Parameter
Replies: 5
Views: 538

Re: Chapter 17 - Disconnected Tables / What-if Parameter

It is not necessary to have a visual on the canvas to use What-if New Parameter. As Matt said, it might be some minor bug somewhere. Save and close the workbook. Reopen it - it might work.
by RamanaV
Sat Nov 07, 2020 10:32 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 17 - Disconnected Tables / What-if Parameter
Replies: 5
Views: 538

Re: Chapter 17 - Disconnected Tables / What-if Parameter

Click on Modeling tab in the menu.
You can then select New Parameter
Chapter17 Image 3.png
Chapter17 Image 3.png (12.48 KiB) Viewed 525 times
by RamanaV
Sat Oct 31, 2020 10:20 am
Forum: Power BI Desktop/Service
Topic: Lookup table that changes over time
Replies: 3
Views: 1130

Re: Lookup table that changes over time

If you want to learn more about dealing with slowly changing dimensions, please consider the online training course Dimensional Modeling for the Power BI Pro by Matt Allington, Ken Puls and Miguel Escobar https://www.skillwave.training/courses/ ... er-bi-pro/
by RamanaV
Wed Oct 28, 2020 10:25 pm
Forum: Power BI Desktop/Service
Topic: How do I update PBI Desktop?
Replies: 1
Views: 255

Re: How do I update PBI Desktop?

First check what version of Power BI Desktop you have.
Click on Help and then on About.
The latest version as of today is October 2020 version.
If you install Power BI Desktop from Microsoft Store, then it gets updated automatically

Go to advanced search

cron