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 everybody
I am trying to do a YTD calculation, the measure works well till it find a blank count in a date. The key points are:
Measure
**bleep**. Count =
Thanks a lot.
Solved! Go to Solution.
@Anonymous , check one more thing. Join is single directional
If this does not help
Can you share a sample pbix after removing sensitive data.
@Anonymous , the month name in the visual is coming from the date table? if not then its should come from that. Also, make sure you marked the date table as date table
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
Hi @amitchandak yes the month comes from the Date Table and the table is marked as date table
@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 thanks a lot, the Cross Filter Direction of the relation was set to both I changed to single and it solved my problem.
@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 dates
Other 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.
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |