Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
Is it possible to combine these two measure into 1? They are working.
Measure 1 to calculate the value for the next day
com_test =
VAR PriorDay = SELECTEDVALUE(table1[date])+1
RETURN
CALCULATE(
( SUM(table1[gb_total_supply])),
ALL ( table1[date]),
table1[date] = PriorDay
)
Measure 2 to calculate the diffrence between the next day and today
com_test minus measure1 =
[com_test] - SUM(table1[gb_total_supply])
Use earlier function in your filter section to compare overall row.
But i am not what is your requirement.
Can you share sample data and expected output?
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |