Search found 9 matches

by RamanaV
Tue May 22, 2018 3:09 pm
Forum: PowerPivot/DAX
Topic: PowerBi Matrix Subtotal Feature & Measures
Replies: 1
Views: 50

Re: PowerBi Matrix Subtotal Feature & Measures

Hi,

How did you define all the measures? I did not look at the dropbox .pbix file.

In DATESBETWEEN function, [Month till where data is available] is used twice. How come?

If you can clarify this, I will look at the output and try to answer your question.
by RamanaV
Tue May 22, 2018 2:47 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: 5: Concept: Filter Propagation [Solved]
Replies: 2
Views: 64

Re: 5: Concept: Filter Propagation [Solved]

Hi, First, a clarification on COUNTROWS and DISTINCTCOUNT: * COUNTROWS returns the total number of rows in the table. So, your number of customers is the total number of rows in the Customers table. * DISTINCTCOUNT returns the number of distinct (unique) values in the column in the table. So, your f...
by RamanaV
Sat May 19, 2018 2:46 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Questions around 2: Concept: Loading Data [Solved]
Replies: 2
Views: 42

Re: Questions around 2: Concept: Loading Data [Solved]

Hi, Here are some clarifications: 1. In the data model you will have lookup tables (dim tables) and data tables (fact tables). In the sample AdventureWorks database, the tables are cleaned and shaped for a direct load into your data model. However, it may not be the case when you get data from else ...
by RamanaV
Wed May 16, 2018 9:11 am
Forum: PowerPivot/DAX
Topic: Pivot Table output help [Solved]
Replies: 2
Views: 141

Re: Pivot Table output help [Solved]

You need to first load your table into Data Model. - Click on Power Pivot tab, and then on Add to Data Model. Next, write 3 measures. To write a measure, click on Power Pivot tab, and then on Measures, and then on New Measure. Total Premium = SUM(DataTable[Premium]) Total Losses = SUM(DataTable[Loss...
by RamanaV
Tue Apr 24, 2018 11:34 am
Forum: PowerPivot/DAX
Topic: #1 Complex Powerpivot requirement
Replies: 2
Views: 168

Re: #1 Complex Powerpivot requirement

Yes, I agree that you came to the right forum for your queries on power pivot or power bi. And, most importantly, you can learn power pivot only by learning how to write DAX formulas. I suggest you attend Matt Allington's online training "Supercharge Power BI", wherein he explains how to w...
by RamanaV
Sun Apr 22, 2018 8:28 pm
Forum: Power BI Desktop/Service
Topic: Best approach to building a data warehouse?
Replies: 1
Views: 86

Re: Best approach to building a data warehouse?

In Power BI, it is possible to connect to different data sources, combine the data, shape the data, do the data modelling, analysis and reporting. Note that in Power BI, there will be only one data model. The data model will have lookup tables and data tables. The best way to organize data in Power ...
by RamanaV
Thu Apr 19, 2018 1:34 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: #47, #49 Using Customer vs. Sales table
Replies: 2
Views: 154

Re: #47, #49 Using Customer vs. Sales table

If you have a filter applied in your Matrix, say on Occupation (this is called Initial Filter Context), your formula returns same values as that of [Total Sales] by Occupation. The eBook formula, on the other hand, overrides the Initial Filter Context (using ALL over the Customers table), and return...
by RamanaV
Sat Apr 07, 2018 10:47 pm
Forum: Power Query
Topic: Check all columns
Replies: 3
Views: 207

Re: Check all columns

You can use Power Query to do this job for you.
Add a custom column so that it takes the discount values if present, otherwise takes 0.
You can then rename the new column as the Discount and delete the column you got from the source
This is a one time job to add query steps.
by RamanaV
Thu Mar 22, 2018 9:56 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Chapter 16 Disconnected Tables: Banding
Replies: 3
Views: 857

Re: Chapter 16 Disconnected Tables: Banding

Age Group is defined as a calculated column in the book. So, your formula is as in the book, but with Age Group:= in the formula bar, which is understood as a measure and hence is not correct. Just add another column, the way you did for Age column, type the formula in formula bar, and then rename t...

Go to advanced search

cron