Search found 5 matches

by jiny680
Sat Mar 10, 2018 5:56 pm
Forum: Power Query
Topic: Help needed for Data Transformation in Powerquery
Replies: 2
Views: 659

Re: Help needed for Data Transformation in Powerquery

First use function List.Dates to transform those two columns into a list of one week dates.
Then expand that list.
Finally unpivot those hour columns.
by jiny680
Thu May 18, 2017 2:48 pm
Forum: PowerPivot/DAX
Topic: Custom calendar time intelligence [Solved]
Replies: 2
Views: 1587

Re: Custom calendar time intelligence [Solved]

Using calculate column
by jiny680
Mon Oct 31, 2016 7:34 pm
Forum: PowerPivot/DAX
Topic: circular dependency error to calculate target stock
Replies: 9
Views: 2566

Re: circular dependency error to calculate target stock

(This reply is not about DAX)

Your Excel file is also "circular dependent" except for one cell "F3"...

And,
To put your Excel formula simpler,
Maybe you can chance that row()=row thing,
For example,F3=CEILING([@[Target demand]],[@[Lot size]])

Go to advanced search