How to efficiently copy - paste a code
1.add this extention to your web browser (Blackbox - Select. Copy. Paste & Search) https://chrome.google.com/webstore/detail/blackbox-sel...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
- May 1, 2022
- 2 min
Compound Annual Growth Rate (CAGR) using DAX
What Is the Compound Annual Growth Rate (CAGR)? The compound annual growth rate (CAGR) is the rate of return (RoR) that would be required...
2,6770
Marek Vavrovic
- Apr 12, 2022
- 1 min
Disconnected Table / Dimension
Power BI Model: I have two tables. Sales with transactions and dimension table for filtering. 1. If no filter is applied. Chart 1: shows...
1370
Marek Vavrovic
- Mar 31, 2022
- 3 min
HuffnerTextile - Data Visualisation PowerBI Desktop
Data Models Data are loaded from the data warehouse database. Using Import Mode. Can't use DirectQuery Mode for Live Connection because I...
360
Marek Vavrovic
- Mar 30, 2022
- 2 min
HuffnerTextile - Tabular Model
HufferTextileDW.abf HuffnerTextile.sln This solution contains 4 Perspectives. The way you create them is when you click on the New...
210
Marek Vavrovic
- Sep 29, 2021
- 6 min
Customers Analysis
Sales Lost Customers Sales Returning Customers Sales New Customers LOST CUSTOMER RETURNING CUSTOMER NEW CUSTOMER Data and data model NEW...
2970
Marek Vavrovic
- Sep 28, 2021
- 1 min
Time intelligence functions, part 04
TOTALMTD , TOTALYTD STARTOFMONTH , STARTOFYEAR PREVIOUSMONTH , PREVIOUSYEAR PREVIOUSDAY Returns a previous day. PREVIOUSDAY(<dates>)...
430
Marek Vavrovic
- Sep 26, 2021
- 2 min
Time intelligence functions, part 03
PARALLELPERIOD , SAMEPERIODLASTYEAR NEXTDAY,NEXTMONTH,NEXTQUARTER,NEXTYEAR FIRSTNONBLANK, LASTNONBLANK FIRSTDATE, LASTDATE FIRSTDATE...
880
Marek Vavrovic
- Sep 24, 2021
- 2 min
Time intelligence functions, part 02
DATEADD, DATESBETWEEN ,DATESINPERIOD DATESMTD,DATESYTD (cumulative total functions, fiscal year) syntax DATEADD(<dates>,<number_of_interv...
1320
Marek Vavrovic
- Sep 23, 2021
- 2 min
Time intelligence functions, part 01
OPENINGBALANCEYEAR OPENINGBALANCEQUARTER OPENINGBALANCEMONTH CLOSINGBALANCEYEAR CLOSINGBALANCEQUARTER ENDOFQUATER CLOSINGBALANCEMONTH...
740
Marek Vavrovic
- Sep 23, 2021
- 2 min
M code, DAX, create a calendar.
Create a calendar in Power Query or using a DAX language. example 1 > M code. This calendar starts from 01. 01.2010 and the dates are...
1390
Marek Vavrovic
- Sep 22, 2021
- 1 min
Information functions, part two
ISERROR ISEMPTY ISBLANK Checks whether a value is blank, and returns TRUE or FALSE. ISBLANK(<value>) return type : Boolean Example 1 I...
440
Marek Vavrovic
- Sep 22, 2021
- 2 min
Information functions, part one
DAX information functions look at the cell or row that is provided as an argument and tells you whether the value matches the expected...
530
Marek Vavrovic
- Sep 21, 2021
- 4 min
Mixed Scenarios.
Links: Grouping a table using SUMMARIZECOLUMN function Cumulative percentage from delivery days New Customer Analysis Calculate running...
1160
Marek Vavrovic
- Sep 19, 2021
- 2 min
Filter Functions, part two.
SELECTEDVALUE KEEPFILTERS EARLIER CALCULATETABLE syntax: CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, …]]]) Every filter...
900
Marek Vavrovic
- Sep 18, 2021
- 3 min
Filter functions, part one
ALLNOBLANKROW ALLCROSSFILTERED ALLSELECTED ALLEXCEPT REMOVEFILTERS ALL Returns all the rows in a table, or all the values in a column,...
2130
Marek Vavrovic
- Sep 15, 2021
- 3 min
Joins with DAX
INTERSECT UNION NATURALINNERJOIN vs NATURALLEFTOUTERJOIN GENERATE vs GENERATEALL I will be using these two tables to demonstrate the...
1,2990