Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
How do I get a Total for Actual in this table?
Actual =
VAR startDate_ = SELECTEDVALUE( 'Products'[Start date])
VAR endDate_ = EDATE ( startDate_, 4 )
VAR Act =
CALCULATE ( SUM ( Sales[Kilos] ), Sales[Invoice date] >= startDate_ && Sales[Invoice date] <= endDate_ ) / 1000
RETURN Act
Best regards
Lotte
@LotteLaugesen , I am assuming this measure and data type is number/decimal
If there no issue try return like
return
sumx(summarize(Table, Table[number], Table[Start Date],"_1"), [Act])
Yes, it is decimal number 🙂
I'm not sure that I understand your solution.
I need both values for Actual per Number and the total for Actual.
@LotteLaugesen ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi
I have added a new file where the calculation is visible 😉
https://1drv.ms/u/s!AoecG91dlcEedQ5858sIN8ZRh9c?e=0ag264
Hope you can help me 🙂
Best regards
Lotte
Hi
I have added a link to the pbix file.
https://1drv.ms/u/s!AoecG91dlcEedFWCA6Fii_s-q9c
I hope you can help me 🙂
Best regards
Lotte
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |