Forum Discussion

LUCASM's avatar
LUCASM
Icon for Helper IV rankHelper IV
3 years ago

CALCULATE TABLE with Filter

I am tring to create a dynamic table from my source table based on a date slicer The date slicer [Period] looks like this "Week 38 2022" - pretty useless in itself I do also have another numeric co...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

sorry it was late and i missed that, he is 100% as you will not have row context which you need for selectedvalue. 

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

what if you created a variable using this?

 

var currdte = CALCULATE ( 'table'(date] ), ALLSELECTED( 'table'[date] ))