DmitriyVlasov

Sparkline Line =
// Sample get from: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/
// Formared width: http://www.daxformatter.com/

// Issue: SparlineMeasure var won't work when referenced (all bars end up 100%)
// Issue: Refactor to avoid nested SUMMARIZEs
// Issue: Negative values currently will not appear
VAR SparklineMeasure =
    SUM ( Sales[SalesAmount] ) // don't use this below per issue above
VAR SparklineMeasureTarget =

DmitriyVlasov

Памятка по сочетаниям клавиш окна редактирования DAX формул Microsoft Power BI

Базовое редактирование

Клавиша		Описание
Ctrl+X		Вырезать строку (Пустое выделение)
Ctrl+C		Скопировать строку (Пустое выделение)
Alt+↑	Alt+↓	Перемещает текущую строку вверх / вниз
Shift+Alt+↑	Shift+Alt+↓	Копирует строку и вставляет её выше / ниже

DmitriyVlasov

#I "../lib"
#r "FSharp.Markdown.dll"
#r "FSharp.Literate.dll"
#r "Deedle.dll"

open System.IO
open Deedle
open Deedle.Internal
open FSharp.Literate
open FSharp.Markdown

DmitriyVlasov

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

DmitriyVlasov

// https://msdn.microsoft.com/ru-ru/library/system.windows.forms.powerstatus(v=vs.110).aspx
// http://www.codeproject.com/Articles/30414/Getting-Started-in-F-A-Windows-Forms-Application
open System
open System.Drawing
open System.Windows.Forms

type MainForm() as form = 
  inherit Form()
  // Define private variables

DmitriyVlasov

Latency numbers every programmer should know

L1 cache reference ......................... 0.5 ns
Branch mispredict ............................ 5 ns
L2 cache reference ........................... 7 ns
Mutex lock/unlock ........................... 25 ns
Main memory reference ...................... 100 ns             
Compress 1K bytes with Zippy ............. 3,000 ns  =   3 µs
Send 2K bytes over 1 Gbps network ....... 20,000 ns  =  20 µs
SSD random read ........................ 150,000 ns  = 150 µs

Read 1 MB sequentially from memory ..... 250,000 ns = 250 µs

DmitriyVlasov

//------------------------------------------
// Step 0. Boilerplate to get the paket.exe tool
 
open System
open System.IO
 
Environment.CurrentDirectory <- __SOURCE_DIRECTORY__
 
if not (File.Exists "paket.exe") then
    let url = "http://fsprojects.github.io/Paket/stable"

DmitriyVlasov

// Делаем текущий каталог рабочей директорией
System.Environment.CurrentDirectory <- __SOURCE_DIRECTORY__

// Если файл paket.exe не существует загружаем его
if not (System.IO.File.Exists "paket.exe") then
  let url = "http://fsprojects.github.io/Paket/stable"
  use wc = new System.Net.WebClient()
  let tmp = System.IO.Path.GetTempFileName()
  let stable = wc.DownloadString(url)
  wc.DownloadFile(stable,tmp)

DmitriyVlasov

#I @"../../packages/FSharp.Data/lib/net40"

#r @"FSharp.Data.dll"

open FSharp.Data

[<Literal>]
let ianaCsvSample = "Name,Template,Reference
1d-interleaved-parityfec,application/1d-interleaved-parityfec,[RFC6015]"

DmitriyVlasov

// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
// THE SOFTWARE.

namespace Utility