创建“自上次刷新以来"关键绩效指标? [英] Creating a "since last refresh" KPI?

问题描述

我有一个 PowerBI，它可以从 Excel 电子表格中提取系统当前状态的清单，让我们简单说一下，我有一个指标显示完成 40%".

I have a PowerBI that pulls from an excel spreadsheet a current inventory of statuses of a system, lets make it easy and say I have a single measure that reads "40% complete".

如果我刷新 PowerBI 数据集，现在显示60%"，有没有办法让 KPI 自动显示 +20%?我发现的每个示例都要求您拥有另一个保留历史数据的数据集，而在这种情况下这不是一个真正的选择.有没有办法计算它或将其存储在 PowerBI 查询本身中?

If I refresh the PowerBI dataset and it now says "60%", is there any way to have a KPI automatically show +20%? Every example I've found requires you to have another dataset that keeps the historical data, and that's not really an option in this situation. Is there any way to calculate it or store it within the PowerBI query itself?

推荐答案

Power BI 并非旨在存储历史数据.这就是数据库的用途.

Power BI is not designed to store historical data. This is what a database is for.

为了计算这 20% 的差异，您需要将历史数据存储在某处，但 Power BI 的目的是连接到源并加载数据，然后将其可视化，而不是充当数据存储库.

In order to calculate that 20% difference, you need to store historical data somewhere but Power BI's purpose is to connect to sources and load data and then visualize it, not to act as a data repository.

这篇关于创建“自上次刷新以来"关键绩效指标?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！