Forum Discussion
Blank result with TYD Calculation
Anonymous , check one more thing. Join is single directional
If this does not help
Can you share a sample pbix after removing sensitive data.
Hi amitchandak yes the month comes from the Date Table and the table is marked as date table
Super UserAnonymous , check one more thing. Join is single directional
If this does not help
Can you share a sample pbix after removing sensitive data.
Hi amitchandak thanks a lot, the Cross Filter Direction of the relation was set to both I changed to single and it solved my problem.
- amitchandak
Anonymous , Good it get solved.
There can 6 reasons - Listed in this blog-https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
Use Date Table (Join with Fact Date)
The date table is marked as a date table
Use columns from the date table
The date does not have a timestamp
The date table has all datesOther than these, bidirectional join with date table can also cause failure, because this can filter dates on date table and we might lose continuous dates.