Forum Discussion
Visual breaks when I add my date from date table
- 3 years ago
nic88 , This means createdon has a timestamp and not visible because you have use date datatype in dax
Create a new column
Created Date = datevalue([createdon])
or
mark the column as date datatype in Power query
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
nic88 , This means createdon has a timestamp and not visible because you have use date datatype in dax
Create a new column
Created Date = datevalue([createdon])
or
mark the column as date datatype in Power query
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
- nic883 years agoFrequent Visitor
This worked! Thank you so much, my head was spinning.