Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
aignn
Helper II
Helper II

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 Date is less than selected in filter.

 

How can this be done? Thanks in advance

6 REPLIES 6
mwegener
Most Valuable Professional
Most Valuable Professional

Hi @aignn ,

 

has your question been answered?

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


mwegener
Most Valuable Professional
Most Valuable Professional

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


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:

test2-1

 

what i need:

test2-2

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.

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.

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] )
    )

3.PNG

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.

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
Most Valuable Professional
Most Valuable Professional

Hi @aignn 

 

can't you use the date slicer Before?

Before.png

If I answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.