Power BI Lesson 4: Measures vs Calculated Columns
Understand the difference that confuses every beginner: calculated columns compute per row and are stored; measures compute on the fly in filter context. Whenβ¦
Read article βExcel, SAP, Oracle & automation tips β plus wacky facts
Understand the difference that confuses every beginner: calculated columns compute per row and are stored; measures compute on the fly in filter context. Whenβ¦
Read article βConnect tables in the Model view: one-to-many relationships, cardinality, single vs both cross-filter direction, active and inactive relationships, and fixing the blank row andβ¦
Read article βCreate a VBA UserForm for clean data entry: design the form, fill drop-downs from a table, validate inputs, add rows to an Excel Table,β¦
Read article βSTDEV estimates the standard deviation from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier stillβ¦
Read article βDB calculates depreciation using a fixed-rate declining balance derived from cost, salvage and life, with an optional first-year month count.
Read article βFinancialLevel: IntermediateAvailable in: Excel 2007+SLN returns equal depreciation for each period of an asset's life.Syntax=SLN(cost, salvage.
Read article βSummarise data with SQL GROUP BY, filter groups with HAVING, and understand the difference from WHERE β explained for Excel users with pivot-table comparisons.
Read article βCUMIPMT totals the interest paid between two payment numbers β e.g. for one financial year. CUMPRINC does the same for principal.
Read article βThe 20 Linux terminal commands you need when you first log in to a server β moving around, reading logs, finding files, permissions andβ¦
Read article βIPMT returns how much of a given EMI is interest; PPMT returns the principal part. Together they always equal PMT.
Read article βMathLevel: BeginnerAvailable in: Excel 2007+SQRT returns the positive square root.Syntax=SQRT(number)ArgumentWhat it meansnumberZero or.
Read article βSIGN returns 1 for positive, β1 for negative and 0 for zero β neat for direction arrows and counting gains vs losses.
Read article βYou blink around 15β20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.