Forum Discussion

Satch's avatar
Satch
Helper III
8 years ago

Create separate table with Inventamount per month

Hi, I want to build historical data from my import. Will explain:   Every day I get the data from an xml file, it's something like ITEM     QTY   COSTPRICE Item A     2          10 Item B     ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Satch,

 

I found a solution here: Storing-and-using-information-from-a-dynamic-data-source-using. You can have a try. I think this is almost impossible with Power BI Desktop only. I can make some explanation.

1. Power BI aims at data analysis and visualization.

2. If we start doing this, we need to get date and total amount. There is no dates. So a possible try is functions like TODAY() and NOW(). But the functions are dynamic. For example, we opened the file yesterday, now() is yesterday. And we open it today, the now() surely return today. So there is no way to keep historical data.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Every refreshing or opening up will lead update.

You can submit or vote an idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=historical

 

Best Regards!

Dale

Satch's avatar
Satch
Helper III
8 years ago

Thanks,

 

I was looking for something simple in Power BI.But as you said, it seems impossible to do that.

 

I have found a way to get my graphs, by exporting once per month a Table visualisation with the total Amount and date to a file.

It involves 1 manual action, but it's easy and stable.