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.
Hello,
i'm trying to create a date table based on the date value of a column within a different table.
This is what a got so far:
Using this DAX i can create a table with one column based on the values in the other table/column:
Hi @icturion
You may also use CALENDARAUTO Function.If you have other question,please share more details for us so that we could help further on it.If not,please accept the reply as solution to close this thread.
Regards,
Hi @icturion
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Hi,
The problem still exists. I am currently working around it by building the calendar table per calculated column. what i'm actually looking for is one dax code that is derived from a date column in another table.
regards
icturion
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |