❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥 Download the pbix file used in this video from : drive.google.com/file/d/1yRJZpR0NILbpImaBUwMZ0duVIWLsH5NJ/view?usp=share_link
In sales table we have products and some agents name.letz say there is a product xyz and there is an agent name A and there are sales given month wise Jan ,Feb....how to write dax to provide sum of a sales by agent A of product XYZ in the month of JAN
Hi Sakshi..Sorry am travelling as we speak .Why dont you just drag the product , Agent and month column in a table .That will give their unique occurances.Then simply create a sum(Sales ) measure.
@@sakshinaik05 Well it depends on your data and the columns you are pulling in your visual.You have to provide me with more details as I am not sure what is your exact requirement dear. As far as i understand your problem .drag the product , Agent and month column in a table and create a simple dax of sum(Sales)
❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file used in this video from :
drive.google.com/file/d/1yRJZpR0NILbpImaBUwMZ0duVIWLsH5NJ/view?usp=share_link
Can you make more videos like this ..its a really great informative series
More to come!
for third question this also work
SWITCH(SELECTEDVALUE(financials[Year]),
2014,"current year ",
"sales in " )
Yes bro ..It depends on the logic
Very nice video.
And one more que. How did u do that animated card.. Advertisement type.
thnx Nimika .. I had used a viz called scroller and cretaed a hardcoded column with the scrolling text .If you like my videos plz do subscribe :)
@@powerbizone Thank you for providing this option.
@@nimikajadav3004 Most welcome !
Tysm for your time n efforts
Most welcome dear! Happy learning
Wonderful brother great work kudos to your efforts 👏👏👏
Thank you so much !
Thank you sir
Welcome Akshay!
very nice thanks
Most welcome
What will happen if chart size is small & user need multiple selection ( consider 3 years)
I will try to make a video on multiselect year soon..For chart size you can alwys adjust fonts .
nice bro
thnx bro
In sales table we have products and some agents name.letz say there is a product xyz and there is an agent name A and there are sales given month wise Jan ,Feb....how to write dax to provide sum of a sales by agent A of product XYZ in the month of JAN
Hi Sakshi..Sorry am travelling as we speak .Why dont you just drag the product , Agent and month column in a table .That will give their unique occurances.Then simply create a sum(Sales ) measure.
@@powerbizone how to do this using dax?
@@sakshinaik05 Well it depends on your data and the columns you are pulling in your visual.You have to provide me with more details as I am not sure what is your exact requirement dear. As far as i understand your problem .drag the product , Agent and month column in a table and create a simple dax of sum(Sales)