Skip to main content

Replies

ahmad · 1 month ago
Sum of the scrap column, done in one minute. But then I thought — is scrap already removed from produced quantity, or is produced before scrap? This changes the whole meaning. Did anyone check the data dictionary?
admin_findi360 · 4 weeks ago
Yes. Don’t build the month in the fact table. The dataset has a DimDate table with a YearMonth column already, related on DateKey. Put DimDate[YearMonth] on the axis and your net sales measure on the values, sort by value, and the top bar is your answer. One date table serves every time question in the set.

Sign in to reply to this thread

Reading is open to everyone. To reply, compare your result or post your approach you need a free findi360 account and a public username — your email is never shown.