Cashflow / P&L Statement in Power BI - (May 2024 Update)

Подписаться 28 тыс.

Просмотров 12 тыс.

50% 1

Learn how to make this with my guided tutorial.
::::::::::: Links :::::::::::::::
🔥 PBIX here: github.com/Pow...
🔥 Power BI May 2024 update: www.microsoft....
🔥 Matrix Layout updates: www.linkedin.c...
🔥 NATIVE Power BI Table - Advanced tutorial: • NATIVE Power BI Table ...
🔥Andrzej's Github: github.com/ava....
🔥Andrzej's IBCS video: • Want to Upgrade Your P...
::::::::::::::::::::::::::::::::::
Come find me on Linkedin: / injae-park
Thanks for taking the time to watch this video.
#PowerBI #DataAnalytics #BusinessIntelligence #powerquery

Наука

Опубликовано:

29 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@Filip.S. 3 месяца назад

love the usage of the calculation group! really clever way to avoid adding the same condition to each and every measure

@PowerBIPark 3 месяца назад

It feels hacky, but at least it works 😊

@williamthedataprof 3 месяца назад

That was helpful especially seeing the new matrix updates in action

@PowerBIPark 3 месяца назад

Appreciate it 😃

@naylord5 3 месяца назад

Excellent content! Thank you so much for sharing 🔥 Definitely the workaround feels a little too hacky, but sometimes it's the only way to get things done. I use a dummy measure with = "000000" to get a fixed width, and I really feel like it could be a better way, but I didn't find it yet.

@PowerBIPark 3 месяца назад

I Appreciate the comment! Yeah a lot of things in Power bi do feel super hacky, I'm even making that one of the topics for my conference sessions xD

@arbazahmad7177 3 месяца назад

Excellent 🎉.. thanks for sharing

@PowerBIPark 3 месяца назад

Thanks for watching!

@jaimerrojasrojas5924 2 месяца назад

Great!!! The initial balance is a value already calculated in your DATA, please I need a guide to calculate the initial balance of a period with DAX.

@TheDarkchaos25 2 месяца назад

so eveyrthing is free , and you used the latest matrix visuals update ? i'll do it later thi sweek, thanks a lot, we need more tutorials like this :) other question, at 11min when you set the format and display units for each specific column, can't you do it for several column in the same time ,

@Nikol_YouTube 2 месяца назад

Hi Injae, thank you for this and all your work! All i came to say is, that I needed more than one row to have a single line, and i created multiple calculated groups, one for each of my items. If anyone used a better way, I would love to know.

@PowerBIPark 2 месяца назад

Thanks! Do you mean that you need one cell to have multiple lines?

@Nikol_YouTube 2 месяца назад

@@PowerBIPark i have multiple rows, a total cash row for example and another 2 rows that do the same thing, they dont have subcategories. I tried to create one calculated group and put all the options there, to select them as items, but it didnt work. it would only fix the first option. I ended up using 3 calculated groups on the filter panel, one for each row i wanted to remove the extra lines from (to remove the repetitive lines in the subcategory part)

@MortenRasmussen73 3 месяца назад

Thank you for an efficient review👌 Very useful! I would greatly appreciate it if you could please make the Excel file available

@PowerBIPark 3 месяца назад

I'm on holidays for 2 weeks, but if you want the data, you can just copy it from the power bi in my github. It's linked in the description. Otherwise, ill add the excel when I'm back to my github

@maciejsuszczewicz3600 3 месяца назад

Great video. Is there a reason you're using 1920x1080 as custom resolution? I saw someone else on LinkedIn saying that this will be a default 16:9 resolution going forward, but spoke directly to Microsoft and they denied...

@PowerBIPark 3 месяца назад

It's because the default 16:9 is low res, and most people look at the report on a 1920*1080 resolution or higher. The main reason I do this is because it's a workaround for getting smaller font sizes (I.e. 8 font size is the minimum, but you can just make the canvas larger), but also it gives you more space in development, just with snapping to grid etc. I do recommend 😉