I have tthree tables in my model:
Finance_Version with the version and the order of each version:
Another table with projects information and other with financial information where we extract the total amount of combination of Finance_Version + Project.
If I combine the three tables in one general visualization table I obtain something like that:
Now I want to have replace the 0,00 and blank values for the last valid value. For example, for project ESBD102, as the last valid value is in F2, I would like for F3 until F11 the value 1.027.373,41 € and in case that we have a new value for F5, then F2, F3, F4 will continue with 1.027.373,41 € and from F5 to F11 will be populated with the new value in F5.
Is posible to create a meaure or new column with that?
Thanks in advance!
@JuanjoMSF sorry taking longer than expected, struggling a bit but will keep trying.. not a simple problem to solve, if anyone wants to chip in feel free..
Sure, here you have the link to an excel with an example.
The excel has three sheets: finance_version, wbs_element and finance.
The match between the tables is the following one:
Finance_version to Finance --> One to many --> Finance_version.Version_ID = Finance.Version
Wbs_element to Finance --> One to Many --> Wbs_element.ROW_ID = Finance.Wbs_element_WID
Thanks in advance for your help,
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.