Search found 33 matches

by Bernard Heymans
Thu Jan 02, 2020 3:01 am
Forum: PowerPivot/DAX
Topic: Row()
Replies: 2
Views: 168

Re: Row()

Not even sure the concept of row exist...

The only solution I see is to create 2 measures & compare them.

like fuel use of cars.
then fuel use of red cars, & fuel use of blue cars,
finally compare red cars to blue ones...
by Bernard Heymans
Thu Dec 12, 2019 2:30 am
Forum: PowerPivot/DAX
Topic: Help Using Subtotals in Division
Replies: 2
Views: 133

Re: Help Using Subtotals in Division

Hi, several ways are possible. = sum(NS) //this is what I will divide / // here I will divide calculate( sum(NS) , // take the NS ALL( 'mydatatable') , // remove all filters 'mydatatable[GlAccountnr]="48750" ) // restrict the table to keep only rows with glaccount= 48750 What does I do: I ...
by Bernard Heymans
Thu Dec 12, 2019 2:12 am
Forum: PowerPivot/DAX
Topic: Max Quantity Between Dates
Replies: 4
Views: 153

Re: Max Quantity Between Dates

Hi Yuin, Actualy if you add a column that contain {15..20} it contains a list between 15 and 20. If I had added a column with { [Start] .. [End] } , I wouild have a list of days between start and end date... As I wanted to work on month base, I converted the [Start] date into a number of month (year...
by Bernard Heymans
Mon Dec 09, 2019 7:39 pm
Forum: PowerPivot/DAX
Topic: Max Quantity Between Dates
Replies: 4
Views: 153

Re: Max Quantity Between Dates

Hi @yuin ,

you have to create a line per month for each entry

if I use 3 machines from june until septembre, I need to see thoses 3 machines in june, july, aug, sept....

I did that in the query.

then you just sum the number of machines


BTW: I deleted your calendar & added mine.
by Bernard Heymans
Mon Dec 09, 2019 7:01 pm
Forum: PowerPivot/DAX
Topic: Accumulate into the past - reverse running total
Replies: 2
Views: 133

Re: Accumulate into the past - reverse running total

I made some...
measures
by Bernard Heymans
Mon Dec 02, 2019 11:45 pm
Forum: PowerPivot/DAX
Topic: Calculating the accumulative by week
Replies: 4
Views: 569

Re: Calculating the accumulative by week

does this help?
by Bernard Heymans
Mon Dec 02, 2019 9:40 pm
Forum: PowerPivot/DAX
Topic: Creating a forecast from Year To Date Values
Replies: 1
Views: 272

Re: Creating a forecast from Year To Date Values

Hi Forecasting is a different job... you base it on exisiting results. then you apply growth ratio on the data. lets say you are selling cars marketing say red cars should grow by 3% Sales say our band is trendy and grow by 2% and that our sales in Germany will not go as good as in the rest of the w...
by Bernard Heymans
Mon Nov 25, 2019 9:14 pm
Forum: PowerPivot/DAX
Topic: Calculating the accumulative by week
Replies: 4
Views: 569

Re: Calculating the accumulative by week

Hi ,

Can you post a small set of data?
without example it is not easy to answer.
by Bernard Heymans
Mon Nov 25, 2019 8:58 pm
Forum: PowerPivot/DAX
Topic: Dynamic Percentile - Year or Month
Replies: 3
Views: 314

Re: Dynamic Percentile - Year or Month

The difference in figure seems to be because you make an average per iteration & per year & then afterwards you make an average per year. My figures are produced making an average par year. So if a year has 8 figure & the next only has 2 , in your way they are calculated with the same we...
by Bernard Heymans
Fri Nov 22, 2019 6:49 pm
Forum: PowerPivot/DAX
Topic: Dynamic Percentile - Year or Month
Replies: 3
Views: 314

Re: Dynamic Percentile - Year or Month

You find here below 2 possible solutions: FIRST: create a measure for each result expected. SECOND: Create a table with all the percentils you want to see. Create a measure (here PC := AVERAGE(percentils[percentils]) on the data table create a measure percentils:= PERCENTIEL.INC(data[Value] , PC) Sh...

Go to advanced search

cron