Forum Discussion
Temporary data
Hi, egrellert
According to your description, you want to store some of the temporary data tables you want in Power BI, first your temporary data table can be a fixed value or a value that is calculated based on the current data.
You can use DAX to generate a dynamic calculated table("New Table") that is calculated from the data, but there is no way this table can be filtered by slicers. If you want to be filtered by filters, you can create a measure and then use var to define variables for virtual tables in the measure("New measure") to save the temporary data or table you need.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, egrellert
According to your description, you want to store some of the temporary data tables you want in Power BI, first your temporary data table can be a fixed value or a value that is calculated based on the current data.
You can use DAX to generate a dynamic calculated table("New Table") that is calculated from the data, but there is no way this table can be filtered by slicers. If you want to be filtered by filters, you can create a measure and then use var to define variables for virtual tables in the measure("New measure") to save the temporary data or table you need.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly