Hi Chandeep. An awesome tip! Nice to see how easily you manipulated GETPIVOTDATA to make your calculation. After seeing this, I'll definitely use it more in the future. Thanks for sharing the example and your wisdom :)) Thumbs up!!
What if you use the arguments as in the formula for the top customers but referencing the pivot table containing just the years. Gotta to try that out. Great trick by the way!
Hi Chandeep. An awesome tip! Nice to see how easily you manipulated GETPIVOTDATA to make your calculation. After seeing this, I'll definitely use it more in the future. Thanks for sharing the example and your wisdom :)) Thumbs up!!
An important note: if you want to make your fact dynamic, you’ll need to wrap it in the TEXT() function
Really a great info that you shared. Thanks for sharing this great info. Am a great fan of your power query works.. 👍💐
Nice trick, I only knew that you could change this into the Backstage of Excel. Thanks.
Congratulations, excellent material 👍
Grt information..
Thanks for sharing! .
good short video on GETPIVOTDATA
Another great video thank you for sharing
nice
Excellent trick
Superb
What if you use the arguments as in the formula for the top customers but referencing the pivot table containing just the years.
Gotta to try that out.
Great trick by the way!
For the year, I think it would show the filtered value for the top 3 customers. Do try it and if it works, please do leave a comment :)
How to return row data, not value column(s) data
How minimum configuration to run power bi smoothly
I am already doing this in my current job. But i am not working as a data analyst....