Forum Discussion

aignn's avatar
aignn
Icon for Helper II rankHelper II
6 years ago

How create new table from another table with dax and filter? (like ALL)

Hello!   I have two tables. Table1 and Table2 Table1 have filter by column Date. I want create new table with dax (like ALL) ,which will have the same columns and rows from Table1, but where Dat...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi aignn ,

Calculated table is static. If you want to create a table based on the selected value dynamically, it is impossible. If you just want to show those values, you could create a measure like below:

Measure =
VAR a =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    IF (
        ISFILTERED ( 'Date'[Date] ),
        CALCULATE ( SUM ( 'Table'[Minutes] ), FILTER ( 'Table', 'Table'[Date] < a ) ),
        SUM ( 'Table'[Minutes] )
    )

Please show more details and screenshots if I misunderstand.

 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.