Power BI刷新多种货币

huangapple go评论65阅读模式
英文:

Power BI refresh multiply currencies

问题

我有一个Power BI仪表板,它正在读取来自Azure存储帐户的.CSV文件。

我正在用它来比较我们的Azure成本,在Power BI Desktop上一切正常。列是从costInBillingCurrency创建的,我为它设置了以下属性:

  • 数据类型:十进制数
  • 格式:货币

然后我将它发布到网上,看到相同的结果。很漂亮。

然后我等待了24小时,数据刷新从Azure存储帐户中获取数据,结果全乱了:

看起来货币被多次乘以了。

发生了什么?

英文:

I have a Power BI dashboard that is reading .CSV files form an Azure Storage Account.

I'm using it to compare our Azure costs and on the Power BI Desktop everything is fine. The columns are created from the costInBillingCurrency to which I gave:

  • Data type: Decimal number
  • Format: Currency

Power BI刷新多种货币

So I publish it online and I see the same result. Beautiful.

Then I wait 24h, the data refresh pulling the data from the Azure Storage Account, all broken:

Power BI刷新多种货币

It seems like that the currency is multiplied multiple times.

What it is going on?

答案1

得分: 0

我将数据类型从“Decimal number”更改为“Fixed decimal number”。

而实际上,这就是钱应该被处理的方式,就像旁边的图标所示:

Power BI刷新多种货币

英文:

I changed the Data type form Decimal number to Fixed decimal number.

And this is actually how money should be treated, as per the icon next to it:

Power BI刷新多种货币

huangapple
  • 本文由 发表于 2023年6月12日 20:30:43
  • 转载请务必保留本文链接:https://go.coder-hub.com/76456694.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定