Search results

thanks for help

thanks for help

hi All how to use power query to transform data like this?

Hi All, how to use VBA auto copy data1 (result/player/1year Score/2year Score) to data2 (follow the match player have play one) ? after that i want the reault is that output there

Thanks for the help....

can you pls edit for me, then send back the power bi sample to me... thanks alot

Hi @Chihiro i think the data wrong calculation.... i want the result is, example: jan 387,500.00 / Feb 488,888.89 / March 422,222.22 / april 437,500.00 Total Average =434,027.78 (i want this Total average 434,027.78 data) and Total Average 434,027.78 - April 437,500.00 , Total = -3,472.22 (i...

hi, i Try you give the code , cant make it can you make code in that power bi , then send it back to me. Thanks

ok, here you go.

hi @Chihiro , this is the sample file... that month i already get each month average sale, then i want this 4 month total average is how much? example: jan 387,500.00 / Feb 488,888.89 / March 422,222.22 / april 437,500.00 Total Average =434,027.78 (i want this Total average 434,027.78 data)...

hi, can you give me that powerbi sample file?

Hi all， this Powerbi pic is per month average sale, how to calculate the latest month april deduct total average?

Hi, If using excel, i want get data from web, but that web have to login, i need how to do only can login and get data? Thanks

hi @Chihiro can you help?

Hi @herofox can make away the error when there is blank? thanks

hi @bosco_yip can make away the error when there is blank? thanks

hi @herofox thanks for help, your formulas is work

hi @bosco_yip thanks for help, your formulas is work

Hi All how to make a formulas to automatic count total deduct Cost = Profit Thanks

hi all anyone can help for this powerpivot?? thanks

Hi all Powerpivot how to make a formulas, if 1 customer continuous negative value for 2 months, then the "red" words will automatically show in the list. if the customer did not continuous negative value for 2 months, then nothing will show up in the list.

hi @rahulshewale1 thanks...it work;)

hi @rahulshewale1 can make that sample file for me? Because not so understand how to make it. pls view attach pic...

hi @rahulshewale1 how about this?

hi @rahulshewale1 how to make this buffered table?