Search found 14 matches

by major
Sat Feb 17, 2018 1:14 am
Forum: PowerPivot/DAX
Topic: Prices dependent on Banding
Replies: 0
Views: 60

Prices dependent on Banding

hi This one's been killing me... and I think I just need a nudge in the right direction, or to be told it ain't possible! I have data model with Sales/Accounts/Products/Bands There's a column in the Accounts table called Accounts[PotentialUnits] which displays a number from 0-6000. The Bands table i...
by major
Fri Jul 15, 2016 6:18 am
Forum: Power BI Desktop/Service
Topic: Total Previous Month as card i.e. no filter context
Replies: 2
Views: 1125

Re: Total Previous Month as card i.e. no filter context

Thanks Matt.

Works perfectly.
by major
Fri Jul 08, 2016 11:02 pm
Forum: Power BI Desktop/Service
Topic: Total Previous Month as card i.e. no filter context
Replies: 2
Views: 1125

Total Previous Month as card i.e. no filter context

How do I display the previous month's total value (sales, units, whatever) as a Card visual in PowerBI, where there is no external filter context? So nothing like a column chart with axis showing month/year. Just a solitary number. I know I need to get the filter context into the formula but I can't...
by major
Thu Apr 07, 2016 6:27 pm
Forum: PowerPivot/DAX
Topic: Sales/Stock - Future Value
Replies: 10
Views: 2660

Re: Sales/Stock - Future Value

Thanks Matt. Think I have a bit more learning to do
by major
Tue Apr 05, 2016 9:00 pm
Forum: PowerPivot/DAX
Topic: Sales/Stock - Future Value
Replies: 10
Views: 2660

Re: Sales/Stock - Future Value

Thanks Matt, this has worked for me. Last question: I know from the off you said no need to have a relationship between calendar and fact table. But I can't figure out why when that relationship is made active on your book (relationship between calendar and Details, either direction but I did calend...
by major
Fri Apr 01, 2016 11:55 pm
Forum: PowerPivot/DAX
Topic: Sales/Stock - Future Value
Replies: 10
Views: 2660

Re: Sales/Stock - Future Value

Thanks for taking the time to look at this. I've tried your solution but I think it misses what I'm after (if I'm wrong, apologies. I am aware of my beginner status). It is a report I need: I need to be able to see, and present to the team daily (hence using BI), the current and future sales pipelin...
by major
Fri Apr 01, 2016 6:57 am
Forum: PowerPivot/DAX
Topic: Sales/Stock - Future Value
Replies: 10
Views: 2660

Re: Sales/Stock - Future Value

Thanks for the link I think what I have in my head isn't possible. I have the sales value and I can divide it by the term to give the per month value. So column b is 12,000 and column c is 1000. In my head I was thinking I need a measure that will sum the per month column value taking into considera...
by major
Fri Apr 01, 2016 5:57 am
Forum: PowerPivot/DAX
Topic: Sales/Stock - Future Value
Replies: 10
Views: 2660

Re: Sales/Stock - Future Value

I'm actually doing it in PowerBi. I'm trying to produce a sales pipeline dashboard. I have 8 sales people completing their own workbooks with quotes issued, closed value etc etc. Then my own book that uses query to consolidate the workbooks. Then powerBI to bring it all together and present it. I'll...
by major
Thu Mar 31, 2016 9:09 pm
Forum: PowerPivot/DAX
Topic: Sales/Stock - Future Value
Replies: 10
Views: 2660

Sales/Stock - Future Value

Hi all I have an issue for which I can find no answer; I don't even know if it's possible, or I'm searching incorrectly. Let's say our business receives an order for 12,000 units on 01/03/16, but these units are to be delivered in increments of 1000 pieces on the 1st of every month for 12 months. Am...
by major
Sat Mar 26, 2016 12:04 am
Forum: PowerPivot/DAX
Topic: Bill of Materials (BoM)
Replies: 7
Views: 2796

Re: Bill of Materials (BoM)

I saw your blog this week; really helpful.

And you got in ahead of the sqlbi chaps - it's been pending on daxpatterns for ages: [http://www.daxpatterns.com/bill-of-materials]

Go to advanced search

cron