Power BI DAX Tips: Generate Larger Sample Data Table with Unique Item Name list

 

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.

Comments

Popular posts from this blog

Power BI DAX Formula for Dynamic Ranking Calculations Based on User Selections and Filters

Power BI DAX and Visualizations: Active employees across time (as x-axis) by Tenure group or age group

Excel VBA Tips: A Macro to Generate Line Chart Dynamically for Loan Schedule Trend Report