Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
i am looking to create a static table that has a month Column that has 12 rows fro the individual months, For example the first row will have a value of January, the second will be February and the 12th will be December.
it seems like something that could be done easily with DAX querries but i'm struggling to find any answers during my google search. Any help will be appreciated
thanks
Solved! Go to Solution.
@Anonymous,
If you're just looking for a simple 1-column, 12-row table, you can use Enter Data to create it yourself. If you need a date table, there's a number of ways to create one. Which do you want?
Go to Edit Queries> Enter Data.
Then enter the Month Name as you enter in Excel. If required enter Month Number as the other column statically and give the Table Name. Click Ok Latter Click on Close & Apply.
Go to Modelling -> New table then key in your table name and values:
Example:
Ex_Table = {"Jan", "Feb","Mar"}
Thanks
Raj
@Anonymous,
If you're just looking for a simple 1-column, 12-row table, you can use Enter Data to create it yourself. If you need a date table, there's a number of ways to create one. Which do you want?
Perfect, just exactly what i need. a little bit embarrassed at how it easy it is.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
72 | |
49 |
User | Count |
---|---|
143 | |
131 | |
109 | |
64 | |
55 |