Forum Discussion
Fill missing stock quantity
Hello, stuck in writing measure. I need to see whole month days and show values for days when values are missing in table. for example, for HTC 8X, it should be showing 1 for days 7-17 april, then ...
Hi Anonymous ,
Inactive the relationship and create measures like below.
Measure = CALCULATE(SUM(Sheet1[QTY]),FILTER(ALL(Sheet1),Sheet1[Name]=SELECTEDVALUE(Sheet1[Name])&&Sheet1[Date]=SELECTEDVALUE('Table'[Date]))) Measure 2 = if(ISBLANK([Measure]),MAXX(filter(ALLSELECTED('Table'),[Measure]<>BLANK()&&'Table'[Date]<SELECTEDVALUE('Table'[Date])),'Table'[Date]),SELECTEDVALUE('Table'[Date])) Measure 3 = CALCULATE(SUM(Sheet1[QTY]),FILTER(ALL(Sheet1),Sheet1[Name]=SELECTEDVALUE(Sheet1[Name])&&Sheet1[Date]=[Measure 2]))Best Regards,
Jay
Hi Anonymous ,
Inactive the relationship and create measures like below.
Measure = CALCULATE(SUM(Sheet1[QTY]),FILTER(ALL(Sheet1),Sheet1[Name]=SELECTEDVALUE(Sheet1[Name])&&Sheet1[Date]=SELECTEDVALUE('Table'[Date])))
Measure 2 = if(ISBLANK([Measure]),MAXX(filter(ALLSELECTED('Table'),[Measure]<>BLANK()&&'Table'[Date]<SELECTEDVALUE('Table'[Date])),'Table'[Date]),SELECTEDVALUE('Table'[Date]))
Measure 3 = CALCULATE(SUM(Sheet1[QTY]),FILTER(ALL(Sheet1),Sheet1[Name]=SELECTEDVALUE(Sheet1[Name])&&Sheet1[Date]=[Measure 2]))
Best Regards,
Jay