Видео

Great way to have data updated via PowerApp. Does the PBI report auto refresh on a browser for other users (not the one entering the changed data in the PowerApp)?

How many refreshed are allowed at day using this method?

It boggles me that there isn't a standard "visualisation" that works as comment capture. It should be as easy as dragging a source and target field onto a "comment visual" and you're done. (Assuming you've got a writable database and permissions set at the back end)

It seems the site is not up anymore. Can someone please share the template?

again i couldent sort and the job not done, is there any thing related to the PBI app update?!

Great video!!! Thank you! Ok I now have 2 tables/jouirnals. actuals and budget - mapping hierarchy is the same. how to build a comparison?

thanks so much man... because of you i'm going be the guy of my office today

Great tutorial and definetely useful. As I'm trying to follow step by step, your final chart using the master formula for the Forecast of Asset/Liabilities Value is impacted by the Contributions parameter (23:40), but the step to include the contribution value isn't part of the formula. Did I over look something? Edit: I just added the two formulas together and used that as the Y Axis value. Hopefully that covers it

Realy impressive and so helpful, I have followed the steps but I am stucked in the sort step, the message keeps appear "We can't sort the 'Level 2' column by 'Sort Order'. There can't be more than one value in 'Sort Order' for the same value in 'Level 2'. Please choose a different column for sorting or update the data in 'Sort Order'." Is this because the embty cell in level 2? but in your vedio it works, i am realy stuck in this step, please help.

Is there a way to sort the second order (Level 2) in a way apart from the normal alphabetical order?

I applied same code-when entering new entry it is working but when I am updating - that is also created a new entry in the list .

When making the MACD, you seem to be using SMAs. In other sources I see them using EMAs. Can you provide some context on your choice here?

Merci !

Hey, thanks for that, it's helping, what about if want to add a columm to calculate % of evolution ?

This is awesome! Although i definitely need a simpler version. What if we just have dividend ETF's?

27:20- I'm stuck here. I'm not getting this graph. I get error message, "Calculation error in 'Measure_Table'[Primary Mortgage Principal Payments]: An argument of function 'PPMT' has the wrong data type or the result is too large or too small." EDIT: only took eight hours of fiddling, but I fixed it.

What a fun project- thanks! It looks like I'm going to have to work till beyond the grave. Does this take pensions into account? I'm in Canada and I'll be getting a few pensions from previous employers.

I really appreciate the comparison between the two Sankey diagram tools in Power BI. Thanks!

this is so helpful, I modified this to fit my needs. I work as a data analyst at a small financial consulting company and I made a flexible template of this- just kept doing the chart of accounts logic for each new company. Ended up automating our financial reporting for 10+ clients, saving us thousands a month as well as freeing up accountants to do other stuff

If you just paste your api key there is it secure from the readers of a published report?

Awesome, great video! Thanks for sharing!

Could you make a similar video where the model allows you to drill down to the month level instead of year?

Could you make a similar video where you go into a more complex model that allows you to drill down in your income statement to the month level?

i got this error 'refresh' is an unknown or unsport function in 'PowerBIIntergraion". I created new PowerApp from Power BI. Do you know why? without this function, the report isn't refresh after submision on power app :(

Would you please share the DAX used to calculate the running CAPEX?

Thanks a Lot for The Resource !

where did the thousand portfolios come from or did I miss that ? brilliant content BTW

Great video and great presenting style thankyou

would be interesting to do SP500 / Nasdaq 100 / and even 2X index trackers :)

wonderful investment advice { OK its not'advice'} in a powerbi channel. Amazing !!

I created a table in powerapps the same as you but i dont see my table as an available data source. This is for a business. I see my environment. There is only one tenant for the business. I dont see any of the custom tables. Why wouldnt i be able to see the tables that i create in the dataverse?

I have some more questions, about how to visualize and don't overload the .ipbix: 1/Timeline values for several tickers, or even extend it further for tickers in one line chart? 2/Visualize the tickers values on the timeline plus sma_12, des_12, tes_12 and so on. 3/ Have be sma_12, des_12, tes_12 calculated in clouds?

Good video, have a question I generated key, inserted it in basic configuration without a password. --> done, why my access can be forbidden?

Not very useful because for my use case I am still not clear how to prepare data, data preparation should have been a component to this video

That was so good! I am starting to get to know Power BI (coming from advanced excel) and this video was perfect! Really clear and lots of content :)

These videos are really awesome, thank you! If you have multiple assets, say a chairlift in 2024 and also again 2026, does that change the formulas?

Any workaround on the Sort by column? It doesn't allow me to sort despite only having unique Sort Order number per each Level 1 for instance. Please help. Thanks!

Hey, could you maybe explain who you created the date column for the Time Series in more detail?

Can anyonr explain me about the tofay variable at 12:03 in tje dax for me its showing error?

Hey @Ptarmy, Thanks for this video. Wonder how do you pass an entire dataset and a question

How does this work with 3 levels? e.g. parent, child and childchild hierarchy

Thanks so much for your help. One issue I came across is that the 10 most recent articles would be just about the same story from 10 different news websites. Any advice?

Can we give an option to the end users, asking questions to chat GPT as an end user after we publish Power BI Report to the services, this will be very useful. ( Just like Q & A , Chat GPT Interface should be created )

A formatting tips & tricks video would be cool as well. I really like how you did the mouse-over tooltip in your ChatGPT video and would love to see how you did it!

Awesome! I can't tell you how helpful your videos have been for me! I really like how you walked through the code in this video. An idea/topic I'd like to see you do a video on would be to use the AlphaVantage "Market News & Sentiment" functions and maybe combine that with some ChatGPT analysis to see if AI can derive insights from the news that connects to the financials (10-K, 10-Q).

Hi, how can you create a SD parameter?

hello a very nice and detailed video sir, Though I am facing a challenge while coding the m code in advance editor I am getting the following error message: "This API function (TIME_SERIES_DAILY_ADJUSTEDSUMBOL=AAPLOUTPUTSIZE=FULL) does not exist." Can you help me with it?

Hi, is the source file still available somewhere, I didn’t find it at the link in the description. Thanks!

19:26 I am getting a error message saying, 'Cannot convert value "None" of type text to type number.'

looks like the formula 'PowerBIIntegration.Refresh()' is no longer valid...was it replaced with something else?