有没有办法展示PowerBI中同一文件的两个版本之间的差异? [英] Is there a way to showcase the differences between two versions of the same file in PowerBI?

问题描述

假设我每天下载一个CSV文件，并希望在信息中心中显示信息中心中同一文件的两个版本(今天和前一天)之间的差异，例如添加到该文件的新行的数量(这些可以定义为新案例)，或从一种类别更改为另一种类别的单元格的数量，例如从仍然生病"变为已恢复".

Let's say that on a daily basis I download a CSV file and I would like to show in the dashboard the differences between the two versions of the same file(today and the day before) in the dashboard such as for example, the number of new rows added to that file(these could be defined as new cases), or the number of cells that were changed from one category to another, such as 'Still Ill' to 'Recovered'.

这是否可以通过DAX表达式或通过在导入时执行的特定转换来实现?还是我应该以某种方式将csv数据附加到原始数据中，然后PowerBI会删除重复数据?

Is this possible to achieve through a DAX Expression or through a specific transformation that is done on import? Or should I somehow append the csv data to the original one and PowerBI would remove the duplicates?

我试图通过以下三个问题来解决问题，但不知何故找不到我需要的答案:

I've attempted to solve the problem through the following three questions but somehow couldn't find the answer I needed there:

检测同一张表的两个版本之间的差异

Python:在两个csv文件之间匹配值

发布两个csv文件之间的计算差异

推荐答案

如果将两个版本的CSV文件都加载到同一PBIX中，则是可能的.

It's possible if you load in both versions of the CSV file into the same PBIX.

否则，答案是Power BI是不是 数据库.

Otherwise, the answer is Power BI is not a database.

这篇关于有没有办法展示PowerBI中同一文件的两个版本之间的差异?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！