CALCULATE in DAX #10: Using TREATAS

Показать описание

Learn how to use TREATAS in CALCULATE filter arguments.

Рекомендации по теме

Комментарии

Hands down ...

When I watch these videos it is like programming poetry. What level!!!!

Thanks

jorparts

This whole series is well worth periodic re-watching.

rcb

TREATAS function always looked strange to me and was never able to understand it until this Video. Thank you Alberto and SQLBI :)

amadiftikhar

Thank you Alberto, it’s great to know TREATAS can be used for this, and supports multiple columns. Especially helpful when we don’t have a relationship between the tables established. Thanks!

mwaltercpa

The best explanation in my opinion for users with intermediate knowledge.

inkuban

Yes, it's very common in queries returned by performance analyser, quick measures.. etc., But still not so common among DAX users, not many people use it at least from what I see. The SQLBI blog about treatas is a wonderful article that describes it's efficiency. Appreciate it. Thank you.👍

Bharath_PBI

These videos are incredibly useful! Thanks for sharing your knowledge :)

VertexRecords

Never used treatas before, but I can see now how useful this is thanks to your great explanation. Thanks again!

danielsiffredi

Have seen Treatas in DAX Studio, was not clear about the semantics behind. Thanks SQLBI ! DAX Master.

莫迪-zw

Thank you. I think the first example is good to demonstrate the general purpose of the function, but it is the second one that highlights the most appropriate use case - it is "IN" functionality but for multiple columns at the same time. Very valuable lesson!

solidoffortitude

Wow! Thanks Alberto ! With this I will be able to solve a scenario.

germanhenriquez

Wooow really I'm feeling great to subscribe the channel and learning DAX in easy understand manner.
Thanks for your effort to share your knowledge 📚 to everyone.

gourisankart

Great! i use your tips to sovle the self-defined date calendar calcuation.
Really Amazing！

beginho

Waoo Amazing Explanation. Thanks Alberto, I really enjoy Dax!

marlonmunozguevara

Thanks so much! Much clearer I was stuck with this function in your book, so this helped a lot. Enjoy DAX ;-)

scramiro

Thanks in a million. Great content. Awesome. Grade: A++💥

johng

Amazing ! Really Helpful...Thanks Alberto

alexandrab

Amazing! Thanks for this great video that explains the TREATAS so well.

wmfexcel

Wooowww it's Amazing... Thank you soomuch...

umasankarthellapuri

So grateful !!!! molte grazie!!!! grazie infinitamente!!!! GRACIAS great work

Pepe

CALCULATE in DAX #10: Using TREATAS

CALCULATE in DAX #10: Using TREATAS

DAX CALCULATE Function Made Easy to Understand (just one word)

Power BI DAX: How to Use the CALCULATE Function

DAX Basics: Filter CONTEXT & Calculate | Power BI Part 1 #PowerBI #design #shorts

Excel 2013 Power BI Tools Part 10 - The CALCULATE function in DAX

CALCULATE in DAX #09: VALUES vs. KEEPFILTERS

📊 How to use Power BI DAX - Tutorial

Measures vs. calculated columns in DAX and Power BI

Power BI DAX Demystified: Mastering the CALCULATE Function + All, AllExcepts, RemoveFilters & mo...

DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship

FILTER CONTEXT & CALCULATE | DAX Essentials 1 #shorts

Power BI DAX Tutorial (4/50) - What is calculate Function

What is Calculate Function in Power BI DAX | Use of Power BI DAX CALCULATE

DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions

CALCULATE in DAX #01: Filters are tables

DAX Basics: Calculated Column, MEASURES & Iterators | Power BI Part 4 #PowerBI #dax #shorts

Using the SELECTEDVALUE function in DAX

DAX in 10! Episode 2: Calculated Columns vs Measures

Calculate Transactions In Last N Days in Power BI Using DAX

DAX in 10! Episode 4: The CALCULATE Function

Use DAX to Calculate Running Totals in Power BI

DAX Fridays! #5: CALCULATE (Part 1)

What is the CALCULATE function in DAX / Power BI?

[DAX] Power of CALCULATE inc ALL, DIVIDE & VAR | Power BI Basics