Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everyone,
I need some help to build a logic that sum the first data from "_MG_price" column (01/04/2023) with the non-blank values from the "_price" column and filldown those values.
The expected result would something like this:
01/04 - 5,2141
02/04 - 5,2141
03/04 - 5,2141+(-0,0373) = 5,1768
04/04 - 5,1768
05/04 - 5,1768
06/04 - 5,1768
07/04 - 5,1768
08/04 - 5,1768
09/04 - 5,1768
10/04 - 5,1768+(-0,0185) = 5,1583
11/04 - 5,1583
.
.
.
I tried already some builds, but none of them worked so far (both columns in that table are measures). Thank you to all in advance.
Solved! Go to Solution.
pls see if this is what you want
Proud to be a Super User!
Looks like a standard running total calculation where you add _price and _MG_price of all prior dates and the current date.
pls see if this is what you want
Proud to be a Super User!
Hi @ryan_mayu , thanks for your help, that's exactly what I needed! I just adapted those ALL functions to ALLSELECT since my table is filtered, but it worked just fine.
Seems thats I was trying to do so much for a simple thing haha, thanks!
Cheers
you are welcome
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |