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.
Hello,
I know this question gets post here a lot but i cant seem to get it working for me.
I Have the folowin data model in SSAS tab:
The table DM_Voorraad contains the inventory data per product, per day. This data is split into total value, quantity an weight for that product at the end of the day and the differerence from the last mutation in the columns delta value, delta quantity and delta weight.
I used the formula:
which seems to be working fine untill i select a date. In that case this formula will calculate the sum of the mutation in the selected date period.
I need a query that either sums all the data outside the selected period up to the max selected date, OR select the latest total value for each product.
Sincerely,
Erik Venema
Solved! Go to Solution.
@Anonymous
It seems that you may simply add ALL Function.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
@Anonymous
It seems that you may simply add ALL Function.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |