Ivan Bondarenko (@_Ivan_Bond) profile picture

Ivan Bondarenko

@_Ivan_Bond

Data / Business Analyst, Excel Pro, Power Query, PowerPivot / DAX / VBA / SQL developer, blogger (https://teapawt.org/t.co/L9lwswucl7)

 Sydney, New South Wales
linkedin.com/in/bondarenkoivan/
Joined October 2010
  • Tweets2.3K
  • Following112
  • Followers760
323Media
Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)Photo by Ivan Bondarenko (@_Ivan_Bond)
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk8 Oct 2022
New PBIX file download options in the #PowerBI service!
Image from Daniil Maslyuk (@DMaslyuk)
11
57
4
342
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk4 Oct 2022
You can now view your deployment pipeline history in the #PowerBI service!
Image from Daniil Maslyuk (@DMaslyuk)
1
6
1
35
Ivan Bondarenko retweeted
Joe McDaid (@jjmcdaid) profile picture
Joe McDaid
@jjmcdaid29 Sep 2022
I'm excited to announce that the latest set of Excel functions are generally available. 🎉 They simplify common text manipulation tasks and unlock dynamic array scenarios. TEXTBEFORE/AFTER, TEXTSPLIT, EXPAND, TAKE, DROP, V/HSTACK, CHOOSEROWS/COLS, TOROW/COL and WRAPROWS/COLS.
2
22
4
73
Ivan Bondarenko retweeted
Christopher Webb (@cwebb_bi) profile picture
Christopher Webb@cwebb_bi16 Aug 2022
New DAX function in #PowerBI: EvaluateAndLog. This will be incredibly useful for debugging! See the great Jeffrey Wang’s blog for details: pbidax.wordpress.com/2022/08…
Introduce the DAX EvaluateAndLog Function

Introduce the DAX EvaluateAndLog Function

There is a hidden gem in the August 2022 release of Power BI Desktop: a secret new DAX function EvaluateAndLog that is not listed in the feature summary of the official blogpost. Yet this function …

pbidax.wordpress.com
3
48
2
133
Have you ever tried the Cluster values feature in #PowerQuery? Cluster values automatically create groups with similar values using a fuzzy matching algorithm, and then maps each column's value to the best-matched group #TransformTuesday docs.microsoft.com/power-que…
Cluster values entry point in the Power Query ribbon inside of the Add column tab

ALT Cluster values entry point in the Power Query ribbon inside of the Add column tab

Cluster values dialog where the column 'Person' has been selected and the new column name has been set to 'Cluster'

ALT Cluster values dialog where the column 'Person' has been selected and the new column name has been set to 'Cluster'

The result of the Cluster values operation over the Person column that yields a new Cluster column

ALT The result of the Cluster values operation over the Person column that yields a new Cluster column

3
11
1
42
Ivan Bondarenko retweeted
Ben Gribaudo (@bgribaudo) profile picture
Ben Gribaudo
@bgribaudo30 Jun 2022
Just updated "Literal Attributes" in Power Query M Primer (part 21) - Identifier Scope & Sections. Now features a slightly more commonplace use case for literal attributes. bengribaudo.com/blog/2021/07… #PowerQuery #MLanguage
Screenshot showing a query/section member's description stored in literal attribute "Description"

ALT Screenshot showing a query/section member's description stored in literal attribute "Description"

6
1
18
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk7 Jun 2022
How can you hide 0 in #DAX in #PowerBI? I'm showing one bad and two better ways: xxlbi.com/blog/power-bi-anti…

Power BI Antipatterns #11: Hiding 0 in DAX

This blog post shows a common (bad) way of hiding 0 in DAX measures in Power BI and two better ways, highlighting the performance/readability trade-off.

xxlbi.com
1
12
34
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk24 May 2022
Besides potential performance degradation, you should avoid filtering whole tables in #DAX in #PowerBI because sometimes you may get unexpected results: xxlbi.com/blog/power-bi-anti…

Power BI Antipatterns #10: Filtering whole tables, part II

Besides potential performance degradation, you should avoid filtering whole tables in DAX because sometimes you may get unexpected results.

xxlbi.com
4
15
Ivan Bondarenko retweeted
Christopher Webb (@cwebb_bi) profile picture
Christopher Webb@cwebb_bi10 May 2022
#PowerQuery Refresh is now generally available for selected data sources - techcommunity.microsoft.com/…
Power Query Refresh is now generally available in Excel for the web

Power Query Refresh is now generally available in Excel for the web

Power Query Refresh is now generally available in Excel for the web for refresh from the current workbook and anonymous OData feeds 

techcommunity.microsoft.com
1
13
3
41
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk9 Apr 2022
A bunch of formatting improvements landed in the #PowerBI service. Guess what this means for Power BI Desktop?
Image from Daniil Maslyuk (@DMaslyuk)
Image from Daniil Maslyuk (@DMaslyuk)
Image from Daniil Maslyuk (@DMaslyuk)
10
49
Great news!
Joe McDaid (@jjmcdaid) profile pictureJoe McDaid
@jjmcdaid16 Mar 2022
We are bringing 14 new functions to Excel. These functions will help you manipulate text and arrays via formulas. TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK,TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, EXPAND, CHOOSEROWS and CHOOSECOLS techcommunity.microsoft.com/…
New Excel Functions

New Excel Functions

We are excited to announce fourteen new Excel functions that will allow you to easily manipulate text and arrays.

techcommunity.microsoft.com
3
Ivan Bondarenko retweeted
Ken Puls, FCPA, FCMA (@kpuls) profile picture
Ken Puls, FCPA, FCMA@kpuls9 Mar 2022
My next Ask Skillwave livestream with @ExceleratorBI is happening on Mar 16 @ 2pm PDT (which is Mar 17 @ 8am for Matt). Join us here on the @skillwave_ account, or on YouTube at skw-t.com/yt. If you have a question or topic idea, submit it at skw-t.com/askus
Image from Ken Puls, FCPA, FCMA (@kpuls)
1
2
Ivan Bondarenko retweeted
Christopher Webb (@cwebb_bi) profile picture
Christopher Webb@cwebb_bi27 Feb 2022
Refreshing #Excel #PowerQuery queries with VBA and #PowerAutomate for desktop blog.crossjoin.co.uk/2022/02…

Refreshing Excel Power Query Queries With VBA And Power Automate For Desktop

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are …

blog.crossjoin.co.uk
1
26
1
61
Ivan Bondarenko retweeted
Matt Allington (@ExceleratorBI) profile picture
Matt Allington@ExceleratorBI8 Feb 2022
Come join Reid and me tomorrow when we do a live stream/chat about the fabulous InfoRiver custom visual. See how easy it is to get "spreadsheet like" features right inside Power BI.
Havens Consulting (@HavensBI) profile pictureHavens Consulting@HavensBI31 Jan 2022
Join @ExceleratorBI and I next Tuesday February 8th @ 2PM (PST) as we breakdown the numerous features in the InfoRiver visual that lets you get to fast insights and analytics using the custom visual. 🧙🏻‍♂️📊✨ bit.ly/inforiverhc
Image from Havens Consulting (@HavensBI)
6
15
Ivan Bondarenko retweeted
James Dales (@jamesdales) profile picture
James Dales@jamesdales16 Jan 2022
Excited to share that I'll be speaking at #sqlbits this year. Looking forward to sharing some #powerbi #maps magic. Celebrating by playing Space Invaders inside Power BI! Have a go: icon-map.com/pbix/SpaceInvad…
1
8
31
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk12 Jan 2022
Heads-up: the Microsoft Certified: Data Analyst Associate certification (exam DA-100) will be renamed to Microsoft Certified: #PowerBI Data Analyst Associate (exam PL-300): techcommunity.microsoft.com/…

Announcing a new name for the Data Analyst Associate certification | Microsoft Community Hub

The renamed Power BI Data Analyst Associate certification goes live in February 2022.

techcommunity.microsoft.com
2
17
42
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk13 Dec 2021
Native sparklines in #PowerBI service!!!
11
44
2
226
Ivan Bondarenko retweeted
Daniil Maslyuk (@DMaslyuk) profile picture
Daniil Maslyuk
@DMaslyuk18 Oct 2021
In #PowerBI dataflows, you can now select the data type when writing your #PowerQuery custom column formula! The feature uses Table.TransformColumnTypes instead of the fourth argument of Table.AddColumn.
4
23
93
Ivan Bondarenko retweeted
Christopher Webb (@cwebb_bi) profile picture
Christopher Webb@cwebb_bi10 Oct 2021
Multi-value parameters in #PowerQuery Online #PowerBI blog.crossjoin.co.uk/2021/10…

Multi-Value Parameters In Power Query Online

There’s a nice new feature in Power Query Online (the version of Power Query used in Dataflows): parameters of type List. You can see this as a new option in the Type dropdown in the “M…

blog.crossjoin.co.uk
4
32
3
98
Ivan Bondarenko retweeted
Ben Gribaudo (@bgribaudo) profile picture
Ben Gribaudo
@bgribaudo22 Sep 2021
Just updated "Power Query M Primer (Part 16): Type System I – Basics" to include a brief mention of the internal, secret type action. 🤫 bengribaudo.com/blog/2020/02… #PowerQuery #MLanguage #PowerBI #Excel
5
12
Load more