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.
Solved! Go to Solution.
Hi @mcobelens,
Based on my test, you coud refer to below formula:
X = CALCULATE([Running total upto current month for each year],'Calendar'[Year]=2018)/[Y]
Y = var a=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2014)) var b=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2015)) var c=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2016)) var d=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2017)) return (a+b+c+d)/4
Z = [X]-CALCULATE([Running total upto current month for each year],'Calendar'[Year]=2018)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @mcobelens,
From your description, I could not find any information about the 'Intel'[Balance], and I could not understand your data structure, if you want to calculate the End total, the X should be calculated like the other value in this column, could you please offer me more information and share the pbix file if possible?
Regards,
Daniel He
So, any idea Daniel?
Hi @mcobelens,
Based on my test, you coud refer to below formula:
X = CALCULATE([Running total upto current month for each year],'Calendar'[Year]=2018)/[Y]
Y = var a=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2014)) var b=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2015)) var c=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2016)) var d=CALCULATE([% of totaal],FILTER('Calendar','Calendar'[Year]=2017)) return (a+b+c+d)/4
Z = [X]-CALCULATE([Running total upto current month for each year],'Calendar'[Year]=2018)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi Daniel,
Thanks a lot, that is sort of what I need but is there a way to incorporate these results in the matrix?
Regards,
Marc
Hi @mcobelens,
I am afraid you could not get the values in the Maxtix due to the logic is different.
Regards,
Daniel He
Hi Daniel,
Yeah, I thought so but thanks for your help anyway. I think your solution will also suffice.
thanks a lot!
Regards,
Marc
Hi Daniel, How can I upload a pibx? I created an example but have no ideo on how to upload it?
You can upload the file to One Drive,DropBox Drive or another and publish the link.
Thanks, i added the pibx
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |