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 guys.
I have an weird issue.
I created the CALENDAR table from the FACT table roughly like this:
StartDate = List.Min(XXXXX[YYYYY]), EndDate = List.Max(XXXXX[YYYYY]) NumberOfDays = Duration.Days(Duration.From(EndDate-StartDate)), Source = List.Dates(StartDate,NumberOfDays ,#duration(1,0,0,0)) TableFromList = Table.FromList(Source,Splitter.SplitByNothing(),{"Date"}), ChangeType = Table.TransformColumnTypes(TableFromList,{{"Date", type date}})
It's got a relation, one to many with the FACT table, like normal.
There are other dimension tables too with one to many relations.
I am sure there are no blanks on the CALENDAR table and on the FACT table.
Anyway when I create a table visual on the report view, with fields from the multiple tables shown above, a misterious blank value appears for the date.
There's some data on the table visual for this selection.
I even created an ID column on the FACT table to check which entries were showing as (Blank) date. And the corresponding IDs have indeed a valid date on the FACT table.
This is quite weird, what can I be missing here?
Cheers, thanks in advance!
Solved! Go to Solution.
I think what I did to solve it doesn't make sense, but I increased the CALENDAR table range on before and after the FACT table entries, and the blanks are gone.
I think what I did to solve it doesn't make sense, but I increased the CALENDAR table range on before and after the FACT table entries, and the blanks are gone.
@Anonymous,
DAX adds a new row to the related table that has blanks in every field, and links that new row to the unindexed row to guarantee referential integrity. You may drag date from a calendar table.
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |