How is it this channel has less than 1000 subscribers? You have great content! I hope the channel blows up for you, you’ve clearly put a lot into your videos and I look forward to seeing more.
I looked online, and I I could not find the subfolder info until today. People kept saying that was impossible, and today I'm finding out it's been there the whole time. Very frustrating and also very happy at the same time.
I'm very new to Power BI and your channel already helped me so so much! But this kind of "good practices" video gives me "oh my god, why didn't I do that before?" moments! Thanks! Plus it's in a short format so it makes it a "quick-learn" which can actually turn into a life-saver for newbies like me! Keep up the great work and quality content! ❤
Really nice, I'm doing a piece of work where I will need to handover the maintenance of the report to someone else. Keeping things super-clean with organisation of the data will make a positive difference. I'm implementing what you have demonstrated in this video. Nice.
Thanks for this Bas. You're the best at explaining PowerBI with straightforward, clear instructions and many of your videos have helped me out, particularly this one. Keep up the great work.
Great information..👍I was searching for this.. Thank you for uploading this video. I request you to please make video on " How to publish dashboard/reports to On-premises server"?
Great. Just great. I also like everything nice sorted and organized. Could not find good clear guidance on creating a metrics table. Should have known I first should have searched in your content.......
Everything in Power Bi is sorted in alphabetical order..tables, column names,,,so to control this you can initiate a name with a number: 01 Measure name, 05 columna name just as he said during the video
Superb !!! Thanks for Sharing.Your video's are really good and everything is properly explained. Going to recommend your channels in my Power BI Watsapp groups.
Excellent recommendation to organize Measures. I have a question here: 1. I created a host of measures in my SSAS Model. Can I organize it in similar manner? Please guide. 2. While working, I have also created many measures and surely there are some that are no longer used in my report. Is there a quick way to identify them? 3. If I were to alter my measure name, I need to remember which visuals were they used and fix them one at a time. Is there a better and easier way to achieve this? Advance Thanks.
Really awesome man! I copied this method, but when I tried to export the underlying data, it only shows the measures and the rest of the underlying rows of data is missing. Any thoughts?
Hello, could you help me please: how can i select the earlest date from several dates? I have several columns with dates and i would like to create a new column in which i can see the earlest date of each line. Hope you got my question 😢 Thanks
Great video! Could you briefly explain how the measures still work even if they are in another table which isn't connected to the rest of the tables? Why filters and everything still work? Thank you!
@@HowtoPowerBI I would add one thing: careful about reports that already use the measures from their previous location. Those reports will display only errors. Unfortunately, you'd have to replace the measure with itself. Learned that today the hard way :)
Wow!!! Great content as always. I didn't know the ; tip. Just one question: I'm not sure but I've heard that organizing measures in separate table can affect samrt narratives - truth or myth?
thank you Filip! seems to work for me .. not sure what specific cases that could be where it would have an impact... or maybe an issue in older pbi versions?
@@HowtoPowerBI well not really, copying in the same file. For example, I have made a sales value measure, and want to make for sales units, i just want to copy sales value measure and change it to units. Also I have actual, budget as two different fact tables, and just want to replicate actual measure to budget by just copying and changing to budget table
@@sandymaverick4702 The only other way that I know is by using the modeling view, selecting the measure and then duplicating it to different tables/folders in the modeling view as shown from minute 7:10 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cGnWPua-cmo.html . I believe those are the only 2 options you have without using any external tools.
If you have measures in an existing report and decide to move them into a measures table and the folder structure, do you know if it will break any of the previously created visuals?
@@HowtoPowerBI I need to calculate the average age of this list. The Table visualization does the job this very well with an implicit measure at the bottom of the table. I would like to replace this implicit measure with an explicit measure and place at the same place: bottom of the list. My question: how do I place an explicit measure (I have created) at the bottom of a table, such as the average of a list? I don't know if this is clear. Translated with www.DeepL.com/Translator (free version)
@@HowtoPowerBI Hello, I don't want to take advantage of your kindness. I have a simple problem but I can't explain it well in the screenshot. Do you have a way for me to send you a screenshot that explains my problem please? Thank you in advance.
Hi Great Video! I have one doubt,I have multiple tables if there is any chance to move tables or columns into this folder? like below 1)folder1-->table1-->table1measures 2)folder2-->table2-->table2measures thanks in advance!!
Hi! I did transfer one DAX measure to newly created folder, but I do get an error : " Column cannot be found or used in expression". How should I deal with this?
Hello, I need yours assistance for one thing - I have two different table - Table1 & Table2 Both tables has records with n number of columns, one column is common in both table which is Country. table2 has another field called Status=Active, Inactive. so I want a one output Matrix Table (similarly mentioned below), where I want to get the Count of both tables based on Country Condition: Table1: no condition (count) Table2 : based on Status = Active (countif) Country Count from Table1 Count from Table2 ------------------------------------------------------------------------------------------------------------------- India 23 39 Canada 44 48 Brazil 51 7 United States 17 73 how we can get it in Power Bi, i have made but second table count coming sum of table2 in each row.. please help