Forum Discussion

DYY94's avatar
DYY94
Icon for Helper I rankHelper I
3 years ago

How to create a new Table based on Values in Slicer

Hello Community, 

 

I have created a new table from another table. and i want to get a value based on seleceted value on slicer. 

 

The slicer called Situation. 

 

 

 

 

 

 

 

 

 

 

 

 

In the new table i want to bing ALL  the values from MR/365 based on selected value from Situation

So basiclly as the Situation changes in the slicer i need th data in MR/365 change accordingly. 

 

This is the new table: 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This is MR/365 ( it's a calculated measure): 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MR/365= DATEDIFF (SELECTCOLUMNS(TC,"SITUATION",SELECTEDVALUE(TC[Situation])),SELECTCOLUMNS(BTA_Output,"Maturite",BTA_Output[Maturite]) ,DAY)/365

 

 

Thanks. 

1 Reply