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...
1,2410
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...
400
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...
230
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...
180
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...
930
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>)...
260
Marek Vavrovic
- Sep 26, 2021
- 2 min
Time intelligence functions, part 03
PARALLELPERIOD , SAMEPERIODLASTYEAR NEXTDAY,NEXTMONTH,NEXTQUARTER,NEXTYEAR FIRSTNONBLANK, LASTNONBLANK FIRSTDATE, LASTDATE FIRSTDATE...
560
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...
770
Marek Vavrovic
- Sep 23, 2021
- 2 min
Time intelligence functions, part 01
OPENINGBALANCEYEAR OPENINGBALANCEQUARTER OPENINGBALANCEMONTH CLOSINGBALANCEYEAR CLOSINGBALANCEQUARTER ENDOFQUATER CLOSINGBALANCEMONTH...
470
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...
820
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...
260
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...
290
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...
430
Marek Vavrovic
- Sep 19, 2021
- 2 min
Filter Functions, part two.
SELECTEDVALUE KEEPFILTERS EARLIER CALCULATETABLE syntax: CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, …]]]) Every filter...
420
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,...
1450
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...
4300
Power BI
SSIS
Import .CSV files from web site
Data Refresh - Expression.Error column not found
Covid-19 Dashboard
AdventureWorksDW2017 Dashboard
Wide World Importers Dashboard
Slovakia covid-19
DAX measures for Covid-19
Tesla 2009-2020 Financial reports analysis
Covid 19 Dashboard (OWID)
Huffner Textile Dashboard
Northwind dashboard
File System Task
Sequence Container
Execute SQL Task
For Loop Container
Foreach Loop Container
Project Deployment Model
Slowly Changing Dimensions