Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need to replicate the following Excel formula in Power BI.
I have been trying a few things based on what I could find on the forum, but unfortunately nothing has worked so far.
The problem I'm facing is that the dataflow I'm working with does not carry forward some of the Province values for certain types of items (as shown in the example above). I am looking for a function that would allow me to carry forward those missing Province values and fill in the blanks.
Thanks for your help!
Solved! Go to Solution.
Hi @vroy
Please create a new calculated column
Result =
MAXX (
CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[OrderID] ) ),
TableName[Province]
)
Hi @vroy
Please create a new calculated column
Result =
MAXX (
CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[OrderID] ) ),
TableName[Province]
)
Hi @vroy
This is one of the simplest data transformations that Power Query does for you out of the box. It's about one mouse click away... There is a transformation in PQ called---if I remember right---Fill Down. Just use this and you'll be finished.
User | Count |
---|---|
47 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
56 | |
28 | |
20 | |
16 |