Posts

Showing posts from January, 2023

Power BI Memory and Performance Considerations

Excerpt From Book:  Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next leve l ,  Publication date: 20 Jan 2022, Author: Michiel Rozema, Henk Vlootman 1. Having fewer columns is better. 2. Use the Right data type. 3. Having many rows is no issues, but watch out for many values. 4. Avoid outliers - leave these values blank or choose special value that is close to actual values. 5. Do really need all that history? 6. Split columns for some cases: columns after split should end up with fewer distinct values.   

Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions

Image
  Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions. DAX Codes for generating the DIM table: BP Indicator (Index by DAX) = DataTable ( "Attribute" , STRING, "Indicator" , STRING, "Index" , INTEGER,                {                           { "Systolic BP" , "Systolic" , 1 },                           { "Diastolic BP" , "Diastolic" , 2 },                           { "Heartbeat" , "Pulse" , 3 }                 }                 )

Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT

Image
  Question 1)  raised by my youtube video viewer on 23rd,Jan 2023: This is great. Just what I was looking for. I need to check for blanks in the birthday column because my blank birthdays are causing errors. How would you do this within your code Quick Answer to Question 1) on 23rd Jan 2023: Just a quick suggestion by following code. Age =     VAR MMDD_Num_Today = VALUE ( FORMAT ( TODAY (), "MMDD" ))     VAR MMDD_Num_BD =         IF ( ISBLANK ( 'Measured Personal Data' [Birthday] ),             "Blank" ,             'Measured Personal Data' [Birthday]             )     Return     if ( MMDD_Num_BD = "Blank" , 0 ,         if (             MMDD_Num_Today >= VALUE ( FORMAT ( MMDD_Num_BD , "MMDD" )),             DATEDIFF ( 'Measured Personal Da...