Create Static Tables in DAX Using the DATATABLE Function

[ariarc]

It's been more than two years since this video was made and posted, and yet I haven't seen anyone explain static tables in DAX so clearly and thoroughtly. And believe me, I have looked far and wide. Thank you.

[CJ-jctn]

Thank you Alberto for sharing different ways to create static tables. I wasn't aware of the DATATABLE function and will definitely use this approach going forward. Another SQLBI video, another nugget of knowledge learned !

[davidirias]

You really are the master of masters in POWERBI!!!! Ver helpful.

[stevemorrison]

You have been really great for a novice user ..many thanks

[advent]

Excellent info on creating tables. Thanks

[manjun]

Really helpful content.Thanks Alberto.

[JS-tsvv]

Thank you Sir, I was trying using this way as part of the Selector value to switch between two different measures using two different time attribute (activating by userelationship) to dimdate table. however, it doesnt work as plan. I have tried both using IF and SWITCH with no luck. the scenario is to have a chart that can show volumes either by Fiscal Year or Standard Year base on the selector. Would really appreciate your advise here and thanks in advance for the support!

[jaimeildefonsosegurapena]

You could also add a M expression:
= Table.FromRows(
{
{"LOW", 0, 000},
{"MEDIUM", 100, 1000},
{"HIGH", 1000,
},
type table [#"Price Range" = text, #"Min Price" = number, #"Max Price" = number]
)

[MrSimp]

Hello Alberto- How can one create user defined functions in SSAS cube to be used in DAX query. Something like inbuilt function like DATEVALUE() etc.

[rokiczaaa]

How to do similar table but with measures? I have to combine some measures to create a chart

[tameraziz]

Thank you.. Alberto, I have a real case which requires me to create a dynamic table coming from measures.
Any possible way?

[RM-wzug]

Hello Alberto and thank you for sharing so much of your knowledge. I am relatively new to PBI but have learned a great deal from your videos. I have a challenge for which I can find no solution and wondering if you have ideas. I find myself with an inventory source that does not have a date/time stamp. The data is simply current data based on the latest transactions from the source system so I don't believe I can use incremental refresh. I need to figure out how to create a snap shot of this data each Friday. I am refreshing the data daily and trying to find a way to capture and keep a snapshot with the Friday Date/Time stamps so that I start building a history of inventory as of Friday's each week in a single table. The intent is to create visuals (eventually) that compares current inventory to year ago, month ago, etc. Ideas?

[gondebas]

By your leave, master Alberto, you can give names to columns without SELECTCOLUMNS, as simple as that:
DATATABLE (
"RangeName", STRING,
"Price_Min", INTEGER,
"Price_Max", INTEGER,
{
{ "Low" , 1 , 10 },
{ "Midium", 10 , 10 },
{ "High" , 100 , 1000 }
}
)

[ashishmohan]

Hi
very useful video and very practical need everyone for every project big thanks to share with us.



If it can possible can you plzz provide us excel data file which you used.

Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[BernatAgulloRosello]

What about loading an excel file? You just need to modify the excel and refresh the table 😊 and you can create calculated columns (like a dynamic max value) workout trouble

[Alpacastanm]

How can we use data table but use measures and dynamic formulas instead of static data?