Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape 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.
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
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.
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 @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.
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:
what i need:
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.
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.
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.
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
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
86 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |