M.Y. BI and Analytics

  In previous video I have shared a method on how to generate a sample dataset with random numerical numbers and random string names via DAX formula. Those generated string name could be not unique.  In this video I shall share an another method to generate sample dataset with larger row numbers which has unique string item name in each row.  for example, I combine the 3 English Uppercase letters to make a unique product name, each letter in the product name comes from the 26 English uppercase letters. Thus in mathematical formula we are able to create 26*26*26=17576  total unique product name in numbers.

  Two years ago I have shared a video regarding a method on how to use DAX formulas to create the Combined Row level Security and Column level Security solution without external tool for an organization hierarchy which has mixed solid line managers and Dot line managers. If you have no chance to watch the videos please refer to the links in this video descriptions.  In that shared power BI report, due to the inflexible DAX formula to calculate the dot line manager path in the fact table “Employee Hierarchy Table”, the solution has limitations to handle more than one dot line managers parallelly in organization hierarchy, such scenarios In my practices could be that we have the different types of Dot line managers in the organization hierarchy, for example Financial Controllers and HR managers etc. they might be in same or even different layers to backup each other, and further the FC can view all sales and cost related figures under his/her layer but not above, HR can view sal...