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.
I want to make a measure that take the july sale and repeat it in to the future. I thougt it should be an easy case but I cant manage.
Her is my measure:
CALCULATE([Totalsalg - Juli];filter(factData;factData[Dato]>=date(2018;7;1)))
Her is how I dont want it and want it:
Solved! Go to Solution.
Hi,
Here is the result i got. You may downlod my PBI file from here.
Hope this helps.
Hi,
Here is the result i got. You may downlod my PBI file from here.
Hope this helps.
Thank you so much. It was more complicated than I thought it should be.
You are welcome.
Hi @nankerp,
I'm not so sure how measure 'total slag juli' calculated, please share sample data with measure formula to test.
BTW, nested measure not works properly if internal measure contains filters.
Reference links:
Order of Evaluation in CALCULATE Parameters
Optimizing DAX expressions involving multiple measures
Regards,
Xiaoxin Sheng
Her is the sourcedata.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |