“您能否帮助我解决问题呢?因为我对DAX完全不熟悉,而且英语也不是我的母语,所以我甚至都找不到正确的问题。”
“这里是问题。”
“我有两个表:”
“start_balance”
"输入输出"
我想要得到以下结果:
筛选后的结果(例如年/月 2020/2):
因此,在为年/月选择切片器时,它应该在选择的年/月之前计算余额,然后显示所选的年/月值。
编辑:更正了start_balance表格。
“这里是问题。”
“我有两个表:”
“start_balance”
+------+---------------+
| Type | Start balance |
+------+---------------+
| A | 0 |
| B | 10 |
+------+---------------+
"输入输出"
+------+-------+------+----+-----+
| Year | Month | Type | In | Out |
+------+-------+------+----+-----+
| 2020 | 1 | A | 20 | 20 |
| 2020 | 1 | A | 0 | 10 |
| 2020 | 2 | B | 20 | 0 |
| 2020 | 2 | B | 20 | 10 |
+------+-------+------+----+-----+
我想要得到以下结果:
未过滤:
+------+-------+------+---------+----+-----+------+
| Year | Month | Type | Balance | In | Out | Left |
+------+-------+------+---------+----+-----+------+
| 2020 | 1 | A | 0 | 20 | 20 | 0 |
| 2020 | 1 | B | 10 | 20 | 10 | 20 |
| 2020 | 2 | A | 0 | 20 | 10 | 10 |
| 2020 | 2 | B | 20 | 20 | 10 | 30 |
+------+-------+------+---------+----+-----+------+
筛选后的结果(例如年/月 2020/2):
+------+-------+------+---------+----+-----+------+
| Year | Month | Type | Balance | In | Out | Left |
+------+-------+------+---------+----+-----+------+
| 2020 | 2 | A | 0 | 20 | 10 | 10 |
| 2020 | 2 | B | 20 | 20 | 10 | 30 |
+------+-------+------+---------+----+-----+------+
因此,在为年/月选择切片器时,它应该在选择的年/月之前计算余额,然后显示所选的年/月值。
编辑:更正了start_balance表格。