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
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi 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.

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

Hi! 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:

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Hi aignn 

     

    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'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.

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi aignn ,
    Could you tell me if your problem has been solved? If it is, kindly accpect the helpful answer as a solution. Welcome to share your own solution. More people will benefit from here. If you are still confused about it, please share more details to us.

     

    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.