Forum Discussion
Sofinobi
Helper IV
Helper IVSummarized table from two tables
hello community please if you can help me, i have 2 tables : Product and Date i want to create a summarized table that have a column from Product table (Product) and the (Month year from Date Tabl...
never use SUMMARIZE to add columns!
OverStock Table = ADDCOLUMNS(SUMMARIZE(Sales_Tab,'Product'[Product],'Date'[Month Year]),"AVG Stock",'Measure'[AVG Stock Qte Month],"AVG Sales Qte R3M",'Measure'[AVG Sales Qte R3M],"AVG Price",'Measure'[AVG Price Month])GENERATE ( SUMMARIZE ( 'Sales_Tab', 'Product'[Product] ), ADDCOLUMNS ( SUMMARIZE ( 'Date', 'Date'[Month Year], 'Date'[YearMonth Number] ), "Avg Stock", VAR _date = CALCULATE ( MAX ( 'Date'[Date] ) ) VAR _mon = FORMAT ( MAXX ( FILTER ( ALL ( 'Date'[Date] ), [AVG Stock Qte Month] && 'Date'[Date] <= _date ), 'Date'[Date] ), "mmm yy" ) RETURN CALCULATE ( 'Measure'[AVG Stock Qte Month], 'Date'[Month Year] = _mon, REMOVEFILTERS('Date') ) ) )
SofinobiHelper IV
Helper IVhi all,
finnaly i find a sollution for my table, two expressions give the correct values but it still one expression doesn't show any value
do you have any idea what is the problem?
average3.pbix
thank you
