Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning,
I’ve been struggling for one DAX solution I can’t figure out how to write it.
I’m trying to find the latest purchase price based on the salesdate so I can calculate the Margin of a product on a given date.
I'm getting close with:
As you see, the Purchase_Price_Calculated on 31-jan should be 49, however it's showing 56. It's not giving the last date in the filter.
I'm missing the final piece in this puzzle.
Any help will be appreciated.
Michel
Solved! Go to Solution.
I was able to solve it myself with the following code:
I was able to solve it myself with the following code:
HI
Try this
Hi Semja,
Unfortunatly both solutions give the same wrong result.
Regards
Michel
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |