Search found 55 matches

by Steve_D
Sat Nov 10, 2018 10:40 am
Forum: PowerPivot/DAX
Topic: Filtering a measure created in a virtual table
Replies: 3
Views: 221

Re: Filtering a measure created in a virtual table

I adjusted the Dax to this; SUMMARIZE(Final_Table, [Sub_Name], [Store_Name], "Dist<2.5", FILTER(Final_Table, [Sub-Store Dist] <= 2.5) the returned error was, "The expression refers to multiple columns". Which got me thinking that perhaps I don't need to define the columns to retu...
by Steve_D
Fri Nov 09, 2018 9:52 am
Forum: PowerPivot/DAX
Topic: Filtering a measure created in a virtual table
Replies: 3
Views: 221

Re: Filtering a measure created in a virtual table

PBix file attached with sample data and make table calculation.
by Steve_D
Thu Nov 08, 2018 4:07 pm
Forum: PowerPivot/DAX
Topic: Filtering a measure created in a virtual table
Replies: 3
Views: 221

Filtering a measure created in a virtual table

I've worked my way through the creation of a virtual table that calculates the distance between Lat/Long coordinates for suburbs and Lat/Long coordinates for stores. When I materialise this virtual table through the "Make Table" function I'm able to obtain a table of Suburb Name, Store Nam...
by Steve_D
Fri Sep 15, 2017 9:19 am
Forum: Power BI Desktop/Service
Topic: Where does PBI Service get its Date/Time settings?
Replies: 0
Views: 1728

Where does PBI Service get its Date/Time settings?

Hi there, I'm wondering if anyone knows of a setting that tells Power BI Service to use local Date/Time settings. I have Now() function which reports the date a report is refreshed but when it is uploaded to the service the Now() function reports an earlier date (the day before date). I can't see an...
by Steve_D
Fri Sep 01, 2017 9:34 am
Forum: PowerPivot/DAX
Topic: Calculating the remainder
Replies: 1
Views: 1266

Calculating the remainder

I had a business problem where I filtered a data set with multiple customers which was related to a sales table to show the sales to a customer that was selected. Pretty normal but, then I wanted to know what the sales where for the remaining customers... all others with the exception of those I had...
by Steve_D
Mon May 29, 2017 8:58 am
Forum: Power BI Desktop/Service
Topic: Is this even possible in Power BI
Replies: 4
Views: 2634

Re: Is this even possible in Power BI

Thankyou , I was unaware that you could do that.
by Steve_D
Sun May 28, 2017 1:31 pm
Forum: Power BI Desktop/Service
Topic: Is this even possible in Power BI
Replies: 4
Views: 2634

Re: Is this even possible in Power BI

Thankyou for the suggestion. The issue I found with the, "Enter Data" Table was once the data had been entered the Table became fixed with those values. I was after something I could change the values in the table while in Power BI. From what I've seen, this is not possible in Power BI. To...
by Steve_D
Fri May 05, 2017 10:28 am
Forum: Power BI Desktop/Service
Topic: Risk matrix chart in Power BI
Replies: 6
Views: 4989

Re: Risk matrix chart in Power BI

very clever, I hadn't even thought of that but again as long as you create a formula that constrains the range to a static four quadrants then this would work to. Surely we have a Mathematician in the ranks who can share a formula that will constrain a range of data to a values that range between -1...
by Steve_D
Thu May 04, 2017 12:16 am
Forum: PowerPivot/DAX
Topic: Help with calculating %
Replies: 1
Views: 1569

Re: Help with calculating %

I'm not sure if this helps but, if I understand your example correctly what you are trying to ascertain (as an example) is the % the "On Boarding" type is of "Requests"? therefore, wouldn't it be; Numerator: Count of Request Type = Count(Table[Req type]) Denominator: Count of All...
by Steve_D
Mon May 01, 2017 2:48 pm
Forum: Power BI Desktop/Service
Topic: DAX MTD , QTD , YTD Returning Blanks
Replies: 1
Views: 2080

Re: DAX MTD , QTD , YTD Returning Blanks

Hate to post a dumb response but, anyway for sake of discussion, is your Date.Dim field a contiguous set of dates?

Go to advanced search

cron