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.
Hi All,
I have made a Date table by that formula,
Datetable = ADDCOLUMNS(CALENDAR("25-09-2013","18-01-2018"),"Year",YEAR([Date]),"Monthnumber",FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)
But, when i am using any column of this table for my visualization, it is showing nothing. I am attaching a screenshot for better understanding,
So for that, I wont be able to make any visualization,slicer and wite any formula using this date table.
Please help me to solve this problem. What wrong I have done?
Please answer.
Thanks,
snandy2011
Solved! Go to Solution.
I assume you have related your date table to your main data table?
Is the date table not working on it's own or only when used with the Demo table?
Is the date table not working on it's own or only when used with the Demo table?
@Mbp In both cases..
The date table is not working on it's own and also with the demo table (when i use it with demo table)
Good to hear.
Your script for the date table worked fine for me when I used it.
What ended up being the issue?
@Mbp I forgot to change the data type of the date column of the main table in the query edior.
I assume you have related your date table to your main data table?
@jthomson , I have solved my problem. It is working right now. Thank you very much for your kind reply.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |