The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I'm trying to reproduce this Excel report :
with those formula
For :
Estimated Freight
Add on
Estimated Duty
Overhead
Indirect Manufacturing
Royalties
Payables & Purchases
Orders and Receivables
I added them in Power BI as measures.
The Net Balance is a Cumulative of all those Measures + $906590
and this is the cumulative measure :
but values are not the same between my Excel sheet and PowerBI:
maybe my formulas are wrong. I'm working on it since 2 days ago and I'm blocked.
Any help, please
Hi @tahar1407,
According to your description, it sounds like a common cumulative requirement across multiple fields.
If that is the case, I'd like to suggest you invoke an iterator function to looping on your tables.
Measure =
VAR currDate =
MAX ( Calendar[Date] )
RETURN
SUMX (
FILTER ( ALLSELECTED ( 'Fact' ), 'Fact'[Date] <= currDate ),
[column1] + [column2] + [Meaure1] + [Meaure1]
)
Regards,
Xiaoxin Sheng
Hi,
I need to start my cumulative total on a specific date/week
This is what I have now :
I have this Cumulative Measure :
as you can see, the Total Measure 1 is the total of all columns before
the sum is correct but not the cumulative it should be
($9,408,469) |
Hi @tahar1407,
Any specific calculation for loop in raw measure expressions that you invoke? AFAIK, you can't directly apply multiple aggerations to measure expression or they will show the wrong reuslts.
For this scenario, you can try to create a variable table with summarize function to apply the first aggregation and then use the iterator function to apply the second one.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |