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

问题描述

假设我每天下载一个 CSV 文件，我想在仪表板中显示同一文件的两个版本(今天和前一天)之间的差异，例如，添加到该文件的新行数(这些可以定义为新病例)，或从一个类别更改为另一个类别的单元格数，例如Still Ill Ill"到Recovered".

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 不是 a 数据库.

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

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