Accounts Recorder
Accounts Recorder
  • 13
  • 30 953
How to Convert Month Number to Name in Power Query
#Shorts
You will learn a short M function to convert months number to Name in Power Query.
Переглядів: 21 651

Відео

How to Import transactions in Quickbooks and Visualise in Power BI.How to Import transactions in Quickbooks and Visualise in Power BI.
How to Import transactions in Quickbooks and Visualise in Power BI.
Переглядів 7 тис.3 роки тому
#shorts In this video you'll see quickbooks data visualised in Power BI to assess overall performance MoM, Product wise and Brand wise. New transactions imported to QB would reflect in dashboard upon refresh, no excel file needed.
Quickbooks to Power BIQuickbooks to Power BI
Quickbooks to Power BI
Переглядів 1,6 тис.3 роки тому
In this video you'll see that upon refreshing the Power BI dashboard all the new sales transaction imported in Quickbooks Desktop gets reflected (NO export to Excel required).
Iphone 12 max pro BackIphone 12 max pro Back
Iphone 12 max pro Back
Переглядів 53 роки тому
JON SNOW | YOU WILL BE REMEMBERED AS A HERO.JON SNOW | YOU WILL BE REMEMBERED AS A HERO.
JON SNOW | YOU WILL BE REMEMBERED AS A HERO.
Переглядів 214 роки тому
This is an exciting level 1 of project IGI in which David Jones got killed at the brink of mission completion. Although it was fun to come out in-front of camera to get the forces out of there rooms and then going upstairs and enjoying shooting. A thrilling moment when the last person was approaching him and he had to load the gun at the very same moment.
TAKEN 7 | ME AND MY CPU DURING LOCKDOWNTAKEN 7 | ME AND MY CPU DURING LOCKDOWN
TAKEN 7 | ME AND MY CPU DURING LOCKDOWN
Переглядів 324 роки тому
Experiencing the taken 7 action during lockdown.
HOW TO SUPER CLEAN MECHANICAL KEYBOARDHOW TO SUPER CLEAN MECHANICAL KEYBOARD
HOW TO SUPER CLEAN MECHANICAL KEYBOARD
Переглядів 944 роки тому
In this video I'll demonstrate how to clean a mechanical keyboards the one with white keys that are more prone to dirt. I'll use a dish washing soap to wash keys and a toothbrush to remove dust from the surface of the board.
Super Clean.Super Clean.
Super Clean.
Переглядів 914 роки тому
In this video I'll show you how to super clean you Mac Book charger with simple daily use items.
My name is virus, Honey VirusMy name is virus, Honey Virus
My name is virus, Honey Virus
Переглядів 464 роки тому
I AM TRYING TO FIX THIS.I AM TRYING TO FIX THIS.
I AM TRYING TO FIX THIS.
Переглядів 554 роки тому
Your never know what he is upto.
African Grey "Honey Virus"African Grey "Honey Virus"
African Grey "Honey Virus"
Переглядів 574 роки тому
Meet my lovely and playful african grey (Honey Virus)
DUBAI 4KDUBAI 4K
DUBAI 4K
Переглядів 284 роки тому
UAE, khorfakkan beachUAE, khorfakkan beach
UAE, khorfakkan beach
Переглядів 3647 років тому
Asad Mehmood Live StreamAsad Mehmood Live Stream
Asad Mehmood Live Stream
7 років тому

КОМЕНТАРІ

  • @camil1693
    @camil1693 23 дні тому

    I can't find the quickbooks obcd, how can I create it?

  • @anyam4574
    @anyam4574 Місяць тому

    Sorry, can't see the typed formula

  • @MarcinBialecki10
    @MarcinBialecki10 Місяць тому

    Thanks! :)

  • @paulrobb8697
    @paulrobb8697 Місяць тому

    Thanks so much, everything else I was trying to do wasn't working. This solved it for me :)

  • @Fxingenieria
    @Fxingenieria 2 місяці тому

    Excellent !!!!

  • @subhapriyasanki5241
    @subhapriyasanki5241 2 місяці тому

    very nice brother

  • @taringnima2520
    @taringnima2520 2 місяці тому

    if you want to make video make it clear, don't waste others time!

  • @TERAnalytics
    @TERAnalytics 7 місяців тому

    This was very helpful. thanks

  • @louism.4980
    @louism.4980 Рік тому

    Thanks :)

  • @rabihbadr54
    @rabihbadr54 Рік тому

    Hi. Just curious, how did you create the quickbooks ODBC that you're connecting to?

  • @faith_oseghale
    @faith_oseghale Рік тому

    Very Direct. Thank you. How did you come up with the 29 though?

  • @EmilPaje
    @EmilPaje Рік тому

    Hi can you Share your this design to me? Thanks In Advance

  • @000zeonix000
    @000zeonix000 2 роки тому

    Many thanks for your video!! Amazing solution!!

  • @dacomaco
    @dacomaco 2 роки тому

    Wow, thank you. Why do you multiply for 29?

    • @girdhar3224
      @girdhar3224 Рік тому

      the new column created by the formula would contain the values "January", "February", "March", and "April" respectively, since 1*29 = 29 corresponds to January, 2*29 = 58 corresponds to February, 3*29 = 87 corresponds to March, and 4*29 = 116 corresponds to April.

    • @dacomaco
      @dacomaco Рік тому

      ​@@girdhar3224 yes, I got that after thinking about it. It took ma while to get. Thank you, though.

    • @jorgeluismartineznieto8969
      @jorgeluismartineznieto8969 11 місяців тому

      @@girdhar3224 Sorry, but I still don't get it. What would be the exact point of using 29? Why not the number 1, for example?

    • @Theilencer
      @Theilencer 11 місяців тому

      @@jorgeluismartineznieto8969 The formula gives you a day of the year.

  • @lassejrgensen3794
    @lassejrgensen3794 2 роки тому

    only took an hour to find this solution. THANK YOU!

  • @zxyzxyzyzyugfd
    @zxyzxyzyzyugfd 2 роки тому

    thanks for the video. My issue is i have 2 column : In the first i have month number 1 , and in the second 2021. I want to create a third column which gives me full date end of month: 31.01.2021. Thanks for your help.

    • @emergingfacts511
      @emergingfacts511 2 роки тому

      Hi S.K thanks for watch my video. You need to select both column and merge them and them change the merged column type to DATE. Then Add custom column where you need to write Date.EndOfMonth(select your merged column)=You have End of Month Date. Please feel free to send the you worksheet at info.arecorder@gmail.com should you have any confusion.

  • @sachinsharma-ux9uw
    @sachinsharma-ux9uw 2 роки тому

    can you please share the process

  • @elianarigoni9188
    @elianarigoni9188 3 роки тому

    Hi, great video! Thanks for share your knowledgement. I have a doubt on 0:19, when you selected the tables and imported them in Power Query. How do you set the right data transfer from QBO to Power BI? Could you help me? Thanks

    • @emergingfacts511
      @emergingfacts511 3 роки тому

      Thanks for watching, You can use QBO connector embedded into Power BI desktop. You may reach me out on skype: asad111.am for further details.

    • @thealchemist6133
      @thealchemist6133 2 роки тому

      @@emergingfacts511 hello, how do i find QBO connector? Can you please assist?

  • @asifkaif1512
    @asifkaif1512 4 роки тому

    Best game

  • @asifkaif1512
    @asifkaif1512 4 роки тому

    Good comeback