Forum Discussion
Solution SageMeasures to a separate table
Hello All,
Just curious to know. Is there a way to push measure values into a separate table whenever, the data refreshes.
I have 6 measures, it was calculated based on different criteria. I want to store the measures after every refresh into a separate table.
Example:
Let's assume, i have refreshed the data on 17-Aug-2017 05:30 AM
M1: 67.58%
M2: 89.04%
M3: 87.56%
i would like to see the data as below.
| Date | values |
| 17-08-2017 05:30 | 67.58% |
| 17-08-2017 05:30 | 89.04% |
| 17-08-2017 05:30 | 87.56% |
| 18-08-2017 09:30 | 70.01% |
| 18-08-2017 09:30 | 88.01% |
| 18-08-2017 09:30 | 72.54% |
any clue. Thank you inadvance.
3 Replies
- CahabaData
Memorable Member
The statement that is the measure - is a different object than the statement that is an Append step. So if your question is whether you can use the same statement/object to do double duty the answer is no. But it may be just a simple copy/paste of that measure statement into an append step..... and it will run with every refresh.
v-jiascu-msftMicrosoft Employee
Hi rocky09,
I'm afraid this isn't supported by now. Please have a look at the analysis below.
1. A measure will response the context, which is very dynamic. For instance, SaleAmount = sum('sales'[Quantity]), if you have data for year 2017, the "SaleAmount" would be the total of year 2017. If you have data of year 2016 and 2017, the "SaleAmount" would be the total of year 2016 and 2017.
2. This is something about measures. So this can't be a work of Query Editor. At most we could create a table. But we can't use a measure in a new table directly. So there is no place to store the values.
3. Usually we can get the data of period (or some date point) by formula. Maybe we don't need to store the values.
If you still want this feature, please vote or submit an idea here: power-bi-ideas.
Best Regards!
Dale
- rocky09
Thank you very much for your replies. For now, I will add these values manaully as we don't have proper solution for it. I will make a request in Idea suggestions.
