Search:

Type: Posts; User: scottsen; Keyword(s):

Page 1 of 6 1

1. Thread: DAX - Measure (Whole Total for Product and Group) - Context sensitive

by scottsen
Replies
6
Views
521

Re: DAX - Measure (Whole Total for Product and Group) - Context sensitive

I literally had to go look at what the FILTERS() function was :)

Typically you will see this as

Product total:=calculate(sumx(Tabela1;Tabela1[Value]);ALLEXCEPT(Tabela1, Tabela1[Product]))
or...
2. Thread: A slicer to chosse among multiple filters

by scottsen
Replies
2
Views
426

Re: A slicer to chosse among multiple filters

This feels at least similar to this: Dynamically changing chart axis | Power Pivot | Tiny Lizard

Hopefully that helps.
3. Thread: Sorting portfolios based on criterias

by scottsen
Replies
1
Views
419

Re: Sorting portfolios based on criterias

This should be super close:

=if(tbl1[size] > calculate(MEDIAN(tbl1[size]), FILTER(ALL(tbl1), tbl1[Year] = EARLIER(tbl1[Year]) && tbl1[Exchange] = EARLIER(tbl1[Exchange])), "big", "small")
4. Thread: DISTINCCOUNT where you have two DATA tables is it possible.

by scottsen
Replies
4
Views
635

Re: DISTINCCOUNT where you have two DATA tables is it possible.

Your syntax looks a bit weird to me (in general) -- as it sorta looks like a pattern for solving many to many problems. That said... if a simple distincount(jobs[Provider_Name]) isn't what you want,...
5. Thread: How to use Power Pivot

by scottsen
Replies
4
Views
647

Re: How to use Power Pivot

It is going to depend on the particular model, and you will probably want to totally separate calendar table, and really you should grab Matt or Rob's book... but in general, you will have something...
6. Thread: Differentiating dates in Power Query

by scottsen
Replies
4
Views
496

Re: Differentiating dates in Power Query

I still think you could use length... like... an IF statement to make sure it is 7+ characters long?
7. Thread: Assistance needed with 5 year sales projection for manufacturing company

by scottsen
Replies
3
Views
815

Re: Assistance needed with 5 year sales projection for manufacturing company

If you aren't going to do fancy machine learning, I would personally just math it up, and import the results as a static table. So, maybe... manually do a linear regression on sales vs oil price,...
8. Thread: Assistance needed with 5 year sales projection for manufacturing company

by scottsen
Replies
3
Views
815

Re: Assistance needed with 5 year sales projection for manufacturing company

Well, at least it's a pretty cool and fun project... if a bit challenging :)

To some degree it is probably going to depend on how fancy you want to get with your predictions. If you want to go...
9. Thread: Filter put on measure returning wrong result?

by scottsen
Replies
10
Views
724

Re: Filter put on measure returning wrong result?

Out of pure curiosity, do you want to re-write how I would typically do this?

Total Ext Amount := SUM('Data Warehouse'[Ext Amount])

KPI 2016 := CALCULATE([Total Ext Amount],
...
10. Thread: Filter put on measure returning wrong result?

by scottsen
Replies
10
Views
724

Re: Filter put on measure returning wrong result?

For the most part... slicing on a particular dimension should "just work", unless you are missing a relationship (say, between a sales and customer table).

KPI...
11. Thread: Filter put on measure returning wrong result?

by scottsen
Replies
10
Views
724

Re: Filter put on measure returning wrong result?

Re-reading this, it is not totally clear to me what you are hoping to achieve. If you just leave that clause out what is "wrong" with the output?
12. Thread: PQ Null vs ""

by scottsen
Replies
3
Views
379

Re: PQ Null vs ""

Can you use if [StudentMarker] is null or [StudentMarker] = "" then ?
13. Thread: Filter put on measure returning wrong result?

by scottsen
Replies
10
Views
724

Re: Filter put on measure returning wrong result?

The DAX EARLIER Function | Power Pivot | Tiny Lizard
14. Thread: Filter put on measure returning wrong result?

by scottsen
Replies
10
Views
724

Re: Filter put on measure returning wrong result?

So, I would be doing some guessing and checking. Things I would look at:
* Do you need a RELATED() around the [Customer.Customer Name] ?
* Do you need to throw a CALCULATE() anywhere -- to convert...
15. Thread: Conditional Recursive Calculation [NEED HELP]

by scottsen
Replies
11
Views
1,868

Re: Conditional Recursive Calculation [NEED HELP]

Just in case you misspoke ...

Any chance you actually want a simple running total (plus a floor at 0) ? It's not what you said, but at least that is way easier :)

=calculate(sum([b]) -...
16. Thread: PowerPivot cannot import data type ()

by scottsen
Replies
2
Views
420

Re: PowerPivot cannot import data type ()

Probably early rows had more "int" looking stuff, and it inferred int type. Even without Power Query, I suspect you can just flip the column type to Text, and you will be fine.

by scottsen
Replies
3
Views
522

Re: conditional sorting

This is probably the best reference on RANKX: RANKX-apalooza: Within and Across Groups, With Filters, Etc. - PowerPivotPro but even after reading that, calculated columns somehow makes this even...
18. Thread: Use latest available price to calculate forecast

by scottsen
Replies
6
Views
601

Re: Use latest available price to calculate forecast

A few thoughts:
* I think things will go better if you have a real date/calendar table
* I think things will go better if you break the problem up into smaller measures

by scottsen
Replies
3
Views
522

Re: conditional sorting

Assuming we are talking power pivot and such... (and maybe even if not), I would reshape your data so that it is "long, not wide".

Company, Date, Value
--
CompA, 1/5/14, 1984
CompB, 1/5/14,...

by scottsen
Replies
3
Views
537

Re: DAX Calculation

I would try something like this

[Days in Month] := COUNTROWS(Calendar, Calendar[Date] >= MIN(Loans[StartDate]))
[Total Interest] := SUMX(Loans, [Days In Month] * Loans[LoanAmount] *...

by scottsen
Replies
3
Views
537

Re: DAX Calculation

Can you give us a manual calculation for a few rows to help us better understand what you want?
22. Thread: Good job Matt & Imke

by scottsen
Replies
2
Views
350

Good job Matt & Imke

I have stopped by a few times to answer some questions, but each time... Matt and Imke had it handled. Loving that action :)

:grin::-D
23. Thread: How to delete the top and bottoms rows of each Text file in Power Query

by scottsen
Replies
3
Views
1,893

Re: How to delete the top and bottoms rows of each Text file in Power Query

@kpuls will get you there:
Combine Multiple Excel Workbooks in Power QueryThe Ken Puls (Excelguru) Blog
24. Thread: PowerPvot Sales Without Gap

by scottsen
Replies
3
Views
347

Re: PowerPvot Sales Without Gap

I'd play around with a measure like this:
Last Month with No Sales :=LASTNONBLANK(Calendar[Month], IF ([Sales] = BLANK(), 1))
25. Thread: Changing Filters leaves Running OLAP query on forever

by scottsen
Replies
5
Views
841

Re: Changing Filters leaves Running OLAP query on forever

I would certainly think so... should be just cached results? No idea if they will impact your perf...
Results 1 to 25 of 150
Page 1 of 6 1