Forum Discussion
Automatically store measures in a table after a refresh on a daily basis.
- 3 years ago
If you can provide examples with some sample data , it will help us to answer. Any aggregations to present persistently, I prefer doing in power query.
Since you want to do DAX, it is definitely possible. Try looking into these and see if that helps. Summarize, UNION, SELECTCOLUMNS...
DATATABLE: try checking this article
https://www.sqlbi.com/articles/create-static-tables-in-dax-using-the-datatable-function/
Random example to help you understand and say it can be done.
I am creating a table using UNION of two tables. Each table has to be same number of columns and data types.
Table = UNION ( CALCULATETABLE( SUMMARIZE ( Sales, 'Product'[Category], 'Date'[YYYY-MM], "Measure", "Count", "Count", 'Sales Order'[Orders count] ) , Year('Date'[Date]) = 2020 ) , CALCULATETABLE( SUMMARIZE ( Sales, 'Product'[Category], 'Date'[YYYY-MM], "Measure", "Sales", "Sales", [Total Sales] ) , Year('Date'[Date]) = 2020 ) )Data view tab:
I hope this gives some direction. If this is not what you need, Sorry, please could you provide more info.
Hi,
The table already exists: 'Ticket Trends' table and has just has 4 olumns to track daily results on 4 key meausres that are updated after every refresh.
The purpose of the table to provide a historical trend over time of the four measures that get updated after each refresh.
Attached is a screenshot of the Ticket Trends table copied to excel, as well as a screenshot of the Power BI Model.
My objective is to automatically update the Ticket Trends table by adding a row and populating the daily measure values after each refresh.
If it would help, a quick 15min call may help?
Thanks again to all for your assistance,
Sean.