hohlick

Sparkline Line = 

// Static line color
VAR LineColor = "#01B8AA"

// "Date" field used in this example along the X axis
VAR XMinDate = MIN('Table'[Date])
VAR XMaxDate = MAX('Table'[Date])

// Obtain overall min and overall max measure values when evaluated for each date

hohlick

(ZIPFile) =>
let
    Header = BinaryFormat.Record([      Signature        	= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger32,ByteOrder.LittleEndian),
                                        Version 		= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16,ByteOrder.LittleEndian),
                                        Flags 			= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16,ByteOrder.LittleEndian),
                                        Compression 		= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16,ByteOrder.LittleEndian),
                                        ModTime 		= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16,ByteOrder.LittleEndian),
                                        ModDate 		= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16,ByteOrder.LittleEndian),
                                        CRC32 			= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger32,ByteOrder.LittleEndian),
                                        CompressedSize 		= BinaryFormat.ByteOrde

hohlick

(json) =>
let
//List the expandable columns
    expandableColumns = (_) => List.Accumulate(
                           	Table.ColumnNames(_),
                                {},
                                (s,c)=>s&(if Type.Is(Value.Type(Record.Field(_{0},c)), type record)
					or Type.Is(Value.Type(Record.Field(_{0},c)), type list)
					then {c} 
					else {})