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.
Hi ,
I am trying to calculate dynamicly a target of some percentage of economy rate for purchase managers. For this calculation i am trying to get the monthly purchase sum, the part of this sum from year's total purchace and an averge monthly percent by years (excluding current year, because it is not comlpete).
For calculate an nomthly purchase sum ia used an dax formula :
Solved! Go to Solution.
unfortinately this isn't working, "this year" is not an issue, the problem is thtat the measure not calculating an year's sum , it isshowing me an monthly sum. I attached i picture
Do you need that year sales
Year Sales = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer])))
This Will not give for this year(Incomplete year)
Year Sales = Var _this_year = year(TODAY()) return CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer]),ABS(year(Sales[Sales Date]) <> _this_year)))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
Will less than current year will not work for you
CALCULATE([sumPurchase$],FILTER(dimDate,[year]<[this year])) Or CALCULATE([sumPurchase$],dimDate[year]<[this year])
I am assuming This Year is calculated as Var in formula
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
unfortinately this isn't working, "this year" is not an issue, the problem is thtat the measure not calculating an year's sum , it isshowing me an monthly sum. I attached i picture
Do you need that year sales
Year Sales = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer])))
This Will not give for this year(Incomplete year)
Year Sales = Var _this_year = year(TODAY()) return CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer]),ABS(year(Sales[Sales Date]) <> _this_year)))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
Thanks a lot it is working!!! could ypu explain me a logic of this solition step by step?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |