selecting values from slicer & get the calculated table filtered

[Pankaj_Jangra]

Hi ,

I am trying to resolve a issue in which i have to use Table functions :-

1st :- taking out invoices of one date using table functions ( as measure gives only a scalar output)
2nd :- taking out invoices of other date using table functions 
3rd :- Except(2nd,1st)
4th :- storing as a calculated table 

but now requirement is that we need to give dynamic slicer for dates, & it will give me the invoices for those 
, so my overall requirement is to use slicer at front end and by which i should change my calculate table .
is this possible ?

[Anonymous]

Hi @Pankaj_Jangra,

Power bi does not support to create dynamic calculated column/table based on filter effects. They not work on the same data level and you can't use the child level to affect its parent.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng