Forum Discussion
summarized table with a dynamic filter Is it possible?
Hi , I need some help to create the following summarized table. I have a revenue_data table i need to summarize . At the moment I have to manually enter the 2019 to get this table to run. ...
Anonymous
Try this code please:
March_Table = CALCULATETABLE( SUMMARIZE( Revenue_Data, [Country],[TERRITORY_DETAILED_DESCRIPTION],[BASE_AMOUNT],[DATE]) ,FILTER('Revenue_Data', year(Revenue_Data[DATE])= YEAR(SELECTEDVALUE(Revenue_Data[DATE]))-1) )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserAnonymous
Try this code please:
March_Table =
CALCULATETABLE(
SUMMARIZE(
Revenue_Data,
[Country],[TERRITORY_DETAILED_DESCRIPTION],[BASE_AMOUNT],[DATE])
,FILTER('Revenue_Data',
year(Revenue_Data[DATE])= YEAR(SELECTEDVALUE(Revenue_Data[DATE]))-1)
)________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Thanks! This was really useful