Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |