Forum Discussion

sPowerBi's avatar
sPowerBi
Frequent Visitor
8 years ago

Calculate NPI (non-productive Inventories in DAX

Hi, I want to calculate NPI ( non productive Inverntories) on power bi. I have stock movements table like this. Date Product Code Quantity Price 1.01.2018 B 5 10 2.01.2018 B 6 10 ...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi sPowerBi,

In your thread, there is no [remaining stock] column, is it a measure? Or it's a column in resource table? Could you please share more details?

Thanks,
Angelia

sPowerBi's avatar
sPowerBi
Frequent Visitor
8 years ago

Hi v-huizhn-msft,

 

I just want to calculate "Remaining Stock" measure in Summarize function. After that i want to see sum of Quantity if trancation date the day before 90 days from today. 

 

Thanks