Forum Discussion
KevBI
Helper I
Helper IMeasure in calculated Column not getting Transformed by Time Filter
I have following problem to solve. Spoilage Costs is the sum of costs per Value Stream. The column AOP is a prediction of costs, that gets put into a excel file for every month. The Column AOPWD ...
KevBIHelper I
Helper Iamitchandak
So my calculated Column would look like this :
AOPWD = 'Spoilage AOP 2022'[AOP] / 'Spoilage AOP 2022'[WDMonth] * [workdays]
I already tried to use a Measure but when using a Measure I couldn'T get a Value for every Column, in my case for every Value Stream.
How would I do that calculation in a Measure so i get the correct output for every Value Stream?
I already tried to use a Measure but when using a Measure I couldn'T get a Value for every Column, in my case for every Value Stream.
How would I do that calculation in a Measure so i get the correct output for every Value Stream?