DAX Fridays! #55: Table construct

[@kingparc]

thank you Ruth for this tutorial. You can also make a copy-past of a range from Excel, which is very useful.

[@CurbalEN]

Thanks for sharing Hoss!! /Ruth

[@barttitulaerexcelbart9400]

Hello Ruth, I don't understand this time. Although this is not a complex video. But you can just copy paste from data in Excel. (put the curor in the first "cell"). I think this works very smooth....What is the disadvantage of this method?

[@CurbalEN]

+Bart Titulaer Hi Bart, The table is stored internally in Power Bi so you avoid hardcoded paths and therefore problems with data refresh when moving the file around... Also the user can modify the table without having access to the source as well as ... You avoid having the table in power query when no cleaning is needed. This is a personal preference thing I would say. I love this capability. I should have clarified this in the video, so thanks for asking! /Ruth

[@brianxyz]

Yes you can paste data in from Excel. It will promote your first row to the be the headers but it lets you undo that step.

[@CurbalEN]

+brianxyz Yes, you can do that :) /Ruth

[@excelisfun]

Thanks for the Table Syntax fun : )

[@CurbalEN]

+ExcelIsFun Have a great weekend and thanks for all your support! /Ruth

[@nitinmore7686]

Thank Madam, New learning for me.

[@CurbalEN]

+Nitin More Great! Have a great weekend :) /Ruth

[@sandip_bettereveryday]

In this context of creating a static parameter table, DATATABLE function of DAX is also worth mentioning. Using DATATABLE function one can also define column names, datatypes as well as values.

[@CurbalEN]

+Sandip Mukherjee Hi Sandip, That is true, I should make a video on that! Have a nice weekend :) /Ruth

[@BroadtreeSolutions]

Hey Ruth - I did not know that that. Thanks as always. The brackets are called curly or brace. Ciao :-)

[@CurbalEN]

+Broadtree Solutions Makes sense, curly brackets... that is a nice name :) I would have call it curvy brackets 😁 Happy Friday! /Ruth

[@yonasawoke3609]

Is this equivalent to 'CREATE' table in SQL?

[@CurbalEN]

+Yonas Awoke Like Create table, really handy :) Happy Friday! /Ruth

[@vida1719]

It was interesting to learn how to create a table with one line of code

[@CurbalEN]

+Vida Great trick isn’t it? :) Happy Friday!! /Ruth

[@TheDistractionStudio]

Thank You for this awesome trick!

[@CurbalEN]

+rajan77 you welcome and have a nice weekend! /Ruth

[@stevennye5075]

very helpful

[@CurbalEN]

Thanks for all feedback :) /Ruth

[@anjutamang2542]

we called it "curly Bracket " .

[@CurbalEN]

Thanks!!! /Ruth

[@MrBryantdavis]

Hi Ruth! You asked about the name of {}. [ ] are brackets, and { } are called either curly brackets (because of their curly shape) or braces. en.wikipedia.org/wiki/Bracket A chance for me to contribute! Thank you!!

[@CurbalEN]

+Bryant D Hi Bryant, thanks!! I always forget, so you might need to remind me again :) Have a great Friday!! /Ruth