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,
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.
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 |
---|---|
52 | |
27 | |
24 | |
13 | |
9 |
User | Count |
---|---|
74 | |
58 | |
47 | |
16 | |
12 |