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 All,
I have Quota table in which i have sales for every month(Jan, Feb etc) in this table but the problem is the sales is available in every month fields(below snapshot FYR),
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov |
2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
4 | 55 | 5 | 8 | 7 | 45 | 344 | 44 | 4 | 44 | 33 |
So i want to calculate these sales dynamically and it should pick the current month column when month changes, How we can achieve this. Plz suggest.
I am using the DAX for manual calculation till october but when it comes to Nov this should be dynamic-
Solved! Go to Solution.
Hi @Anonymous
it is no exactly dynamic, I explain it better.
In the formula you must type all the months of the year:
Hi @Anonymous
Try to create the following measure:
Hi @Anonymous
Can you please tell me if month changes to November so this will work or not because I want to add them dynamically when month changes..
Thanks..
Hi @Anonymous
it is no exactly dynamic, I explain it better.
In the formula you must type all the months of the year:
Hi @Anonymous
Thanks for your reply, For now it is working fine...Thanks alot
Hi @Anonymous ,
If your data changes every month, you'd better combine these month columns into a separate month column in your original data source. Then you can create measure like DAX below.
Measure1 = CALCULATE(SUM(Table1[sale]),FILTER(ALLSELECTED(Table1), Table1[Month] =MAX(Table1[Month])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xicai ,
Actually I want to add whole months from January till current month means all month we need to take for calculate sales meanwhile when month changes it should identify the current month and take calculation for that month also.... Hope you understand my query,, Thanks
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |