Search found 32 matches

by a68tbird
Fri Mar 03, 2017 2:41 am
Forum: Power BI Desktop/Service
Topic: Yesterday Sales But Accounting for Weekend
Replies: 1
Views: 1048

Yesterday Sales But Accounting for Weekend

Hello All, I have a client that requires daily sales reports, and so I have created a PowerBI dashboard (embedded on a backend page of their website) that gives YTD sales, as well as Yesterday's sales. But "Yesterday's" sales aren't really all that useful on a Monday morning - I'd rather t...
by a68tbird
Tue Feb 14, 2017 2:31 am
Forum: Power Query
Topic: Help with ReplaceValue and Replacer.ReplaceText
Replies: 2
Views: 943

Re: Help with ReplaceValue and Replacer.ReplaceText

Thanks. I wonder though if this wouldn't be a big performance inhibitor. If I had a million plus rows in my table, and only 1 or 2 rows matched my criteria, we're copying an entire column and then deleting a column just to change those couple of values.
by a68tbird
Sat Feb 11, 2017 7:49 am
Forum: Power Query
Topic: Help with ReplaceValue and Replacer.ReplaceText
Replies: 2
Views: 943

Help with ReplaceValue and Replacer.ReplaceText

Hello All - I'd like to replace the text value of column2 based on the value found in column1. I'm inserting a custom step in my query, and I thought about the following, but didn't work: = Table.ReplaceValue(#"PreviousStep","12345",each _[column2] ="NewProductName",Rep...
by a68tbird
Tue Dec 06, 2016 2:51 am
Forum: PowerPivot/DAX
Topic: Don't Calculate When Sales This Year Are Zero
Replies: 2
Views: 759

Re: Don't Calculate When Sales This Year Are Zero

Thanks very much Owen! Works perfectly.
by a68tbird
Fri Dec 02, 2016 5:32 am
Forum: PowerPivot/DAX
Topic: Don't Calculate When Sales This Year Are Zero
Replies: 2
Views: 759

Don't Calculate When Sales This Year Are Zero

I have a sales report showing product quantity sales this year and product quantity sales last year. Last year is calculated as: = CALCULATE ( Orders[Sum of Quantity], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) ) I also have a % increase measure, shown by: = DIVIDE ( [Sum of...
by a68tbird
Fri Oct 28, 2016 3:58 am
Forum: Power BI Desktop/Service
Topic: Create Word Cloud or Similar
Replies: 2
Views: 1368

Re: Create Word Cloud or Similar

That's great! Thanks!
by a68tbird
Sat Oct 22, 2016 7:03 am
Forum: Power BI Desktop/Service
Topic: Create Word Cloud or Similar
Replies: 2
Views: 1368

Create Word Cloud or Similar

Here's an interesting problem. I have a number of customer checkout surveys that are mostly ratings from 1 to 5 on a handful of questions. But the customers also have the opportunity to leave specific comments. I thought it would be useful to see which words come up most often within these text stri...
by a68tbird
Wed Oct 19, 2016 5:04 am
Forum: Power BI Desktop/Service
Topic: Power Query Function / Get Data from Sharepoint Folder
Replies: 1
Views: 1612

Re: Power Query Function / Get Data from Sharepoint Folder

Hi - Just wanted to share that I managed to figure this out. Instead of using Get Data > Sharepoint Folder, I instead used Get Data > Web and then pointed to the Sharepoint URL where a file lives. It's important to make sure that the URL is free of special characters, or query expressions. I found u...
by a68tbird
Tue Oct 18, 2016 3:27 am
Forum: Power BI Desktop/Service
Topic: Power Query Function / Get Data from Sharepoint Folder
Replies: 1
Views: 1612

Power Query Function / Get Data from Sharepoint Folder

Hi Matt, You helped me previously with an excellent solution for combining CSV files (http://powerpivotforum.com.au/viewtopic.php?f=5&t=499). I'm now hoping I can adapt this same methodology to use in a Power BI solution. The Excel report that I have is great, however after I publish it to our c...
by a68tbird
Fri Oct 07, 2016 4:26 am
Forum: PowerPivot/DAX
Topic: SUM Only When Column Is Blank
Replies: 2
Views: 968

Re: SUM Only When Column Is Blank

Hi - I'm back to this problem again. My formula works great when viewing the totals as a whole, however, I have need to slice the totals on my report by payment method. I'm using cube formulas on my report (=CUBEVALUE("ThisWorkbookDataModel","[Measures].[SumOrdersTotal]","[E...

Go to advanced search