Forum Discussion
Count and Countrows returning 'Blank' Value
Anonymous
Yes, A relationship to the date table, and an indexing table
OK, there are a number of possibilities here.
- Is the relationship with the date table active or inactive?
- Are you sure that the date column in your phone call table is actually the date datatype and not datetime? Like in the query, what is it set to? If it's datetime in the query, even if you set the datatype to date in the Power BI data model it won't work. There are other digits hidden so the dates will never match a date in your date table.
- If none of that solved it, tell me more about this indexing table.
I got $20 on "the date relationship has times in the fact table". You can't JUST change the "Data type" and/or "Format" on the Modeling ribbon... which, I dunno... I think i wish it works for Data Type at least?
You need to change the underlying data to NOT HAVE times (hopefully just using "Edit Queries")
I have stopped creating date tables, and now create additinal columns within the table separating the month, day and year from the date column. After, I create attach an excel spreadsheet with distinct date values. This seems to be easier with lots of tables with multiple dates and years.
The problem was in the indexing table, I made the relationship inactive, and it is now working. I will have to see what the issue is with the relationship.
I just lost $20!? :)
Anonymouscan I claim that you owe me $20 since inactive relationship was #1 on my list? :smileyvery-happy: