Forum Discussion
Days Cover Calculation Per Material
Anonymous ,
You can create a table visual in power pivot and then drag the measure to the table visual.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportAnonymous ,
Generally, you may create a calculate column using DAX below:
Result =
CALCULATE (
SUM ( Table[Days_Cover] ),
FILTER (
Table,
Table[MATNR] = EARLIER ( Table[MATNR] )
&& Table[Year_WeekNo] = EARLIER ( Table[Year_WeekNo] )
)
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Many thanks for your reply...
And what do I put for the Days_Cover calculation?- v-yuta-msft
Anonymous ,
You can create a table visual in power pivot and then drag the measure to the table visual.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-yuta-msft
Anonymous ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao