New Way of DAX with Visual Level Calculations || WINDOW() INDEX() and OFFSET() Functions in Power BI

In This Video -
NEW DAX FUNCTIONS WINDOW(), INDEX(), PARTITIONBY() AND OFFSET()
Visual Level Calculations in Power BI
Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
/ power-bi-helpline-22a2...
Email- [e-mail]
@POWERBIHELPLINE

[@unnikrishnansanthosh]

thank you for sharing, really informative

[@PowerBIHelpline]

Glad to know, you found this helpful🙂

[@wexwexexort]

Not tried but, I think we can even use WINDOW for cumulative totals, by setting the first type ABS and the second one is current row.

[@PowerBIHelpline]

Yes we can do that , these functions are game changer. Those hard coded position parameters can also be replaced with the value from a numeric parameter slicer, which users can select dynamically.

[@spilledgraphics]

Lordy! Lordy! this is amazing. Thanks @Power BI Helpline

[@PowerBIHelpline]

Yes indeed, these new functions are super useful while doing comparison analysis in Power BI.

[@SolidSnake59]

Those functions are basically turning PowerBi into Excel.

[@PowerBIHelpline]

Exactly, A lot of users comes from background, where visual level calculations already exists, and they always try to implement the same kind of functionalities. and Such functions were much needed for this.
But there is a huge scope, when we give flexibility to users to choose the Position parameters, or by using PARTITIONBY() function, we can manipulate these functions for amazing conditional calculations

[@auditandpassion2825]

Amazing!!!!

[@datawhipper]

Thanks for this wonderful explanation.

[@PowerBIHelpline]

Glad to know, you found this helpful, I am also excited to use these functions in many real life scenarios, which were difficult and complex to calculate earlier.

[@mirrrvelll5164]

Very good. Excel is going alive again!!! =)

[@PowerBIHelpline]

Absolutely!

[@ppoorabgmail]

Can we use these functions to fetch string values from a previous or a later occuring row?

[@PowerBIHelpline]

Yes, It fetches previous row value, weather it is text or number. and then you can use CONTAINSTRING() Function like below
Find "e" in Previous Row =
CONTAINSSTRING(
CALCULATE(
MAX('Table'[Fruits]),
OFFSET(-1, ALLSELECTED('Table'[Fruits]))), "e")

[@sardhashakti]

Hi, While sharing a report email comes from Microsoft email id. It is possible to share the report with my email id using the power bi services sharing option?

[@PowerBIHelpline]

I don't think there is such option available, but if you want to send custom emails from your defined email account, you may be able to use Power Automate for this Purpose

[@phanindragaddam7607]

So window() is for running totals ?

[@PowerBIHelpline]

In a way Yes. but isn't it super easy to calculate something on such dynamic ranges, where you can even give flexibility to users to choose those position parameters.
use of PARTITIONBY() is really amazing in conjunction with the function.

[@alyssonmachadoborges3373]

Great video. Can you make this sample file available for download?

[@PowerBIHelpline]

Thanks for posting the comments. Please send an email to [e-mail]. and you will get the PBIX file for the same.👍

[@sandip_bettereveryday]

Please Zoom in while writing the formula. Otherwise in phone, it is difficult to understand.

[@PowerBIHelpline]

Thanks for the superb advise👍

[@shujashakir9952]

Looks like these functions are a direct import from SQL Window functions.

[@PowerBIHelpline]

Yeah! and the latest addition in this series is RANK function as well.

[@subramanianramasamy6524]

because dax is converted to xmSQL or SQL in formula engine

[@wexwexexort]

These are great!