Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |