Search found 52 matches

by Steve_D
Wed Feb 08, 2017 12:37 pm
Forum: PowerPivot/DAX
Topic: Aggregation is not adding up?
Replies: 4
Views: 788

Aggregation is not adding up?

I have a Power BI Table of which a screen shot is shown below. It shows sales by week x Account x State. I have created measures that calculate, aggregated unit sales, Avg Unit Price ( = avg(divide([Total Val],[Total Units])), Std Shelf Price (Max unit price over the prior 28 day period) and Shelf P...
by Steve_D
Mon Jan 16, 2017 9:00 am
Forum: General
Topic: Office 365 Subscriuption
Replies: 3
Views: 901

Re: Office 365 Subscriuption

Thanks Matt, seems silly that there isn't an upgrade path from the old disc/web update Office to the new (and future direction) Office.
by Steve_D
Sun Jan 15, 2017 12:28 pm
Forum: General
Topic: Office 365 Subscriuption
Replies: 3
Views: 901

Office 365 Subscriuption

I have Office 2016 Professional and i was wondering if I should convert to Office 365 so I can get a personal Power BI log in. Is there any functional difference between Office 2016 Pro and Office 365?

The second question is there any easy (read free) transfer from Office Pro to Office 365?
by Steve_D
Thu Dec 29, 2016 7:37 am
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

Brilliant. Have to say this is the annoying thing about DAX... I didn't know averagex existed.
by Steve_D
Wed Dec 21, 2016 12:39 pm
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

This is a sample PBix file with the store count tables built in the queries. I've created some DAX measures to give an idea of the sort of analysis being undertaken.

Fireneeds x Week Sample.pbix
(707.87 KiB) Downloaded 38 times
by Steve_D
Tue Dec 20, 2016 6:01 pm
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

I cant upload a Pbix file. Says its an invalid file extension.
by Steve_D
Tue Dec 20, 2016 3:00 pm
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

Can Do... I will upload a sample PBIX.
by Steve_D
Mon Dec 19, 2016 6:25 pm
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

I've been able to create a passable solution by creating copies (reference table function) of the source file and then grouping the data (summarize function) by State and then group. Trouble is, each reference and summarize reads the sources file which makes the process slow. I'm surprised there isn...
by Steve_D
Sun Dec 18, 2016 12:55 pm
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

some data to muck around with.
Fireneeds x Wk Sample.xlsx
(511.55 KiB) Downloaded 38 times
by Steve_D
Sun Dec 18, 2016 11:33 am
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1344

Re: Aggregating Store Count Measure

Yep, will do. The solution is to create a virtual table... I haven't got that far in my reading yet.

Go to advanced search