Forum Discussion
Storing values in Power BI
Hello Power BI geeks, I am developing a scorecard and the values for Current Month are calculated measures – The current month’s value would be Last Month’s value in the upcoming month meaning le...
Hi mahenkj2 ,thanks for the quick reply, I'll add further.
Hi SM321 ,
Regarding your question, unfortunately Power BI is not a tool for storing data, it is meant for data analysis .If you want to store the results of your metrics into a specific table, perhaps you can refer to the following article for a solution.
Store them somewhere (Azure SQL DB, Datalake, Sharepoint... whatever).Append to the records the date of the snapshot so you can idenity snapshot date.
Solved: Save Measures or Calculated Column Values in a sep... - Microsoft Fabric Community
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.