Search found 53 matches

by RamanaV
Mon Mar 16, 2020 10:56 am
Forum: PowerPivot/DAX
Topic: Running Total in a calculated column [Solved]
Replies: 4
Views: 140

Re: Running Total in a calculated column [Solved]

This should work -
Running Total = SUMX(FILTER(FILTER(InvTable, InvTable[Invoice] = EARLIER(InvTable[Invoice])), InvTable[Index#] <= EARLIER(InvTable[Index#])), InvTable[Amount])
by RamanaV
Sun Mar 15, 2020 2:54 pm
Forum: PowerPivot/DAX
Topic: Running Total in a calculated column [Solved]
Replies: 4
Views: 140

Re: Running Total in a calculated column [Solved]

Hi, You need to use the DAX functions EARLIER and FILTER to address such problems. EARLIER gives the current Row And then FILTER can be used to get all the rows upto the current row. Running Total = SUMX(FILTER(TestTable, TestTable[Index] <= EARLIER(TestTable[Index])), TestTable[Amount]) Refer to Ma...
by RamanaV
Sun Mar 08, 2020 3:40 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Page 15 - Making change to a table..
Replies: 3
Views: 234

Re: Page 15 - Making change to a table..

Hi,

Excel 2013 and Excel 2016/Excel in o365 have many differences in UI for Power Pivot.
Could you please contact me directly via Excelerator BI website https://exceleratorbi.com.au/

Ramana
by RamanaV
Sun Mar 08, 2020 9:43 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Page 15 - Making change to a table..
Replies: 3
Views: 234

Re: Page 15 - Making change to a table..

Hi, The issue is you are reading the first edition of the book which was written using Excel 2013 and you are using the later version of Excel in Office 365. Matt Allington has written the second edition of the book using Excel 2016 and it is named [b]Supercharge Excel[/b]. Please do the following: ...
by RamanaV
Thu Mar 05, 2020 8:22 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Sample Database Download Page5 [Solved]
Replies: 2
Views: 117

Re: Sample Database Download Page5 [Solved]

Hi, I checked just now. I am getting the following message [attachment=0]AW database.png[/attachment] Please do the following: Clear the cache of your web browser Close all tabs in the web browser and then open again. If the issue persists, please take a screenshot so that we will know what's going ...
by RamanaV
Mon Feb 10, 2020 7:22 pm
Forum: PowerPivot/DAX
Topic: DAX Mistery
Replies: 2
Views: 133

Re: DAX Mistery

Hi,

There is no attachment in your post.
If you can include the workbook with data and expected and actual results, it would be easy to understand the issue.
by RamanaV
Fri Feb 07, 2020 7:28 pm
Forum: PowerPivot/DAX
Topic: Handling different granularities
Replies: 6
Views: 625

Re: Handling different granularities

For having totals at the bottom, you don't have to write a different formula.
You have to choose the option for showing subtotals at the bottom instead of top.
Please see the screenshot to know how to do it.
And also the totals are being displayed at the bottom for each group in the Pivot Table.
by RamanaV
Mon Feb 03, 2020 9:25 pm
Forum: PowerPivot/DAX
Topic: Handling different granularities
Replies: 6
Views: 625

Re: Handling different granularities

The first part of the question - A pivot table showing aggregation of Budget at Range and Department levels. Vending Area is at the 3rd level of hierarchy and the budgets are given at that level. So the defined relationships do not work as required. I have defined the relationships as Budget -> Cate...
by RamanaV
Sun Feb 02, 2020 8:48 am
Forum: PowerPivot/DAX
Topic: Handling different granularities
Replies: 6
Views: 625

Re: Handling different granularities

It would be easy to understand the problem and suggest a solution if you can attach a sample workbook.
by RamanaV
Tue Jan 14, 2020 2:20 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: SUMX result in power pivot
Replies: 1
Views: 536

Re: SUMX result in power pivot

SUMX is an aggregation function. That is why you are getting the same result (which is actually the sum of all the products) in every row. You can add a calculated column as = Base[Price]*Base[Quantidade] And, it serves the purpose. However, it is not a good practice to add a calculated column in th...

Go to advanced search

cron