Category: What’s New

What’s new? ( random notes on changes that are new, or, new to me )

What's New

What’s New: May 2023: Dax Functions, and PBI Fabric

Post author By Jake Bolton
Post date 2023-06-09
No Comments on What’s New: May 2023: Dax Functions, and PBI Fabric

Dax Keeps pouring out new Functions.

DAX

So Many New DAX functions

New: MatchBy, Rank, RowNumber, LINEST, LINESTX , Index, Offset, OrderBy, PartitionBy, Window, EvaluateAndLog, ToCsv, ToJson, NetWorkDays [ from 2022-07 to 2023-06 ]
new RANK and ROWNUMBER [2023-04]
ORDERBY was updated [2023-04]
new: INDEX, OFFSET, WINDOW [2022-12]
- there’s a long introduction that covers how and some of why you would use these new functions (no link because that blog had no header permalinks)
community post using many of the new dax functions ( Kumail )
new: EvaluateAndLog, ToCsv, and ToJson [2022-11], docs: EvaluateAndLog
DAXDebugOutput v0.1 [ from Nov2022 ] using sql profiler

CoPilot, and Fabric

CoPilot
Lots of Fabric ( plus half a dozen top level fabric announcements posts, like Data Factory Fabric
You can now Declare your measure with an optional Format()ing measure, without using external tools.

Power BI Feature Summaries

Tags DAX, Fabric, Power BI, What's New

Power BI What's New

Run DAX in Your Browser: SQL-BI.com has a DAX Web App | What’s New

Post author By Jake Bolton
Post date 2021-02-26
No Comments on Run DAX in Your Browser: SQL-BI.com has a DAX Web App | What’s New

The announcement: sqlbi.com/introducing-dax-do

Examples on Dax.Guide have a “try it” button to launch the editor

Tags DAX, Power BI, Web, Web App, What's New

Command Line Getting-Started PowerShell Pwsh7+ Quick Tips What's New

PowerShell : Prefixing lines with the Pipe operator |

Post author By Jake Bolton
Post date 2021-01-09
No Comments on PowerShell : Prefixing lines with the Pipe operator |

There’s a lot of ways to use line continuations in Windows Powershell without backticks . Powershell added a new one, the | pipe operator. It’s cleaner to read, and makes it easier to insert, delete, or toggle comments on the console.

Now you can write:

# Powershell
ls | sort Length
| Select -First 10
| ft Name, Length

Instead of piping on line endings

# Windows Powershell
ls | sort Length |
Select -First 10 |
ft Name, Length

# or
ls | sort Length | Select -First 10 | ft Name, Length

Tags Command Line, Inspection, Powershell, Pwsh, tip, What's New

Power BI Power Query References And Cheat Sheets What's New

Searching Constants Defined in Power Query

Post author By Jake Bolton
Post date 2020-09-11
No Comments on Searching Constants Defined in Power Query

Searching Power Query Language Functions and Constants

Tags Library, Ninmonkey Libs, Power BI, Power Query

Power BI What's New

Power BI Updates – 2020-08-17

Post author By Jake Bolton
Post date 2020-08-21
No Comments on Power BI Updates – 2020-08-17

Guy In a Cube: July roundup

He covers and links these topics:

Extracting data from PDF files
Calculation Groups
Sync Slicers: hatfullofdata.blog/power-bi-introducing-sync-slicers
Patrick uses slicers to control what’s in a report page tooltip
Slicers that span pages

Power BI – Introducing Sync Slicers

PBI Patch Notes Summary

Power BI Desktop July 2020 feature summary

External tools
Gradient Legend
Azure Maps Visual (Preview)
49 new Excel Financial functions in DAX
- New DAX Docs: Financial Functions
- What’s New: Supported DAX function list
option to globally disable automatic type detection

External tools

DAX

CoPilot, and Fabric

Power BI Feature Summaries

Searching Power Query Language Functions and Constants

Guy In a Cube: July roundup

PBI Patch Notes Summary

External tools

Tabular Editor

Dax Studio

ALM Toolkit