The DATATABLE function can create static tables in a Power BI model specifying column names and data types. Article and download: sql.bi/27271/?... How to learn DAX: www.sqlbi.com/... The definitive guide to DAX: www.sqlbi.com/...
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.
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 !
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?
There are examples of similar scenarios in our book: www.sqlbi.com/books/analyzing-data-with-microsoft-power-bi-and-power-pivot-for-excel/ And course: www.sqlbi.com/p/data-modeling-for-power-bi-video-course/
The example with SELECTCOLUMNS uses another syntax - table constructor - which create a table using dynamic expressions (not allowed in DATATABLE) but cannot control the column name directly.
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!
Hi very useful video and very practical need everyone for every project ......very 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
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
A measure can return only a scalar value (string, number). You can create tables in variables within the DAX expression of a measure, but you cannot return them from a measure.