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

Question

Hello!&nbsp;I have two tables.Table1 and Table2Table1 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 Date is less than selected in filter.&nbsp;How can this be done? Thanks in advance

mwegener · Answer

Hi&nbsp;aignn&nbsp;,&nbsp;making a copy of a table is easy.&nbsp;Table2 = Table1&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-calculated-tablesBut calculated tables are calculated during the data load.Slicers only work in the evaluation context.&nbsp;If I answered your question, please mark my post as solution, this will also help others.Please give Kudos for support.

aignn · Answer

Hi!&nbsp;mwegener&nbsp;&nbsp;Thank you for your reply.My example -&nbsp;https://yadi.sk/d/WOB5pcfXT3yT-AI want get data for chart where Date &lt; selected in slicer Date&nbsp;&nbsp;what i have:&nbsp;what i need:

mwegener · Answer

Hi&nbsp;aignn&nbsp;&nbsp;can't you use the date slicer Before?If I answer you question, please mark my post as solution, this will also help others.Please give Kudos for support.

v-xuding-msft · Answer

Hi aignn&nbsp;,
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] &lt; a ) ),
        SUM ( 'Table'[Minutes] )
    )

Please show more details and screenshots if I misunderstand.
&nbsp;
&nbsp;
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.

mwegener · Answer

Hi&nbsp;aignn&nbsp;,&nbsp;has your question been answered?&nbsp;Regards,MarcusDortmund - GermanyIf I answered your question, please mark my post as solution, this will also help others.Please give Kudos for support.

Forum Discussion

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

6 Replies

Related content

Slicer Filtering Another slicer

Filter depending on another filter

Creating a measure that is the value of another measure but ignores a filter

Creating a Date Filter in Power BI

Creating a Measure: Filtering Text Column, with text from another column