help me dax
1 Topic
Hi Team, Pls help this dax calculated table im getting error
ADDCOLUMNS( SUMMARIZE( 'Daily Inventory', 'Daily Inventory'[Country New name] ), "ThisThursdayNetInventory", CALCULATE( [Net Inventory mUSD], FILTER( ALLEXCEPT('Daily Inventory', 'Daily Inventory'[Country New name], 'Daily Inventory'[Location_c], 'Daily Inventory'[Type]), 'Daily Inventory'[Date] = VAR TodayDate = TODAY() VAR ThisThursdayDate = TodayDate + (5 - WEEKDAY(TodayDate, 2)) RETURN ThisThursdayDate ) ), "LastThursdayNetInventory", CALCULATE( [Net Inventory mUSD], FILTER( ALLEXCEPT('Daily Inventory', 'Daily Inventory'[Country New name], 'Daily Inventory'[Location_c], 'Daily Inventory'[Type]), 'Daily Inventory'[Date] = VAR TodayDate = TODAY() VAR LastThursdayDate = TodayDate - WEEKDAY(TodayDate, 2) - 2 RETURN LastThursdayDate ), "Difference", [ThisThursdayNetInventory] - [LastThursdayNetInventory] ) )Solved763Views0likes5Comments