Forum Discussion
aignn
Helper II
Helper IIHow 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...
mwegener
Most Valuable Professional
Most Valuable ProfessionalHi aignn ,
making a copy of a table is easy.
Table2 = Table1
https://docs.microsoft.com/en-us/power-bi/desktop-calculated-tables
But calculated tables are calculated during the data load.
Slicers only work in the evaluation context.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
aignnHelper II
Helper IIHi! mwegener
Thank you for your reply.
My example - https://yadi.sk/d/WOB5pcfXT3yT-A
I want get data for chart where Date < selected in slicer Date
what i have:
what i need: