Forum Discussion
Cubes (SSAS) Date Filters and PowerBI
Is the actual key of the Date dimension a different field? A common approach to these types of tables it to use an integer column and then things like the "Date" field are there but aren't actually used for the FK relationships.
And, where did you change the data type? In the source, data view, query view, etc.?
Yes, the actual key is a surrogate key called DateDimID. Good suggestion, I'll try this out and get back to you.
The datatype was already a datetime field from the source so I didn't really change the datatype per se, just the properties of the dimensions.
Hi did you find any solutions to this. Dont want 2 fields. Any way to hide one field
what is the solution to this issue.
I have also been having this issue (only saw this post now), using date.value seems to solve most of my issues around date functionality, does seem a bit silly though that this does this, so i dont think it needs a solution but it does just create unnecessary complexity, unless someone can explain why this is happening?
