Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data modeling help for a newbie

Hi,   I've only started learning how to use Power BI to replace Excel / Powerpoint reporting and I've only been doing self-study on the foundations and am a bit stumped with data modeling.   I ha...
Need Help
BuckyKat37's avatar
BuckyKat37
Advocate II
3 years ago

For doing this type of grouping I've found it much easier to build a separate Excel file that lists all training titles in one column and then add the group name for each training in a column next to it. Then you can import the Excel file into Power BI and do a merge of the Excel file into your main table. Then you can use that column in any visual without needing to write any code.

 

I'm not in front of Power BI at the moment so I don't want to comment about the other things and lead you down the wrong path if I've got some incorrect things.

 

Also, the Matrix visual is Pivot Tables for Power BI.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi BuckyKat37 and thank you for your input.

    I've done that (list the unique course names and categorized them accordingly) but what puzzles me is when I try to pull them into a new table for the output / data dump that only shows "Y" and "N", the same formula doesn't work for the group with 30+ courses. Maybe I'm doing the formula wrong or rather should be doing it differently where the logic is "if any of these 30+ courses were completed, return "Y", otherwise, return "N". I can't use the IF-OR combo as it would be tedious to manually list all the 30+ courses in the argument) 😞