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.
I have three tables and am trying to use the date table to filter the other two. I have a table to display the Actual and Planned fuel by month. The actual fuel shows one value for a month with a null value and leaves January blank. All files and photos are in the link below. I have searched everywhere but can't figure this out. Any help will be greatly appreciated.
https://drive.google.com/drive/folders/1Y3ik1fMtYjqw146GXqGDwgjMQK0haxM7?usp=sharing
Solved! Go to Solution.
@Anonymous , This means there few dates missing in date table.
Also, the check dates do have a timestamp. if there is then create date like below and join with date table
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))
Hi @Anonymous ,
The above problem may be caused by setting an incomplete time stamp, which results in some field values without corresponding dates. I did the following test and got the correct expected result.
Table = CALENDAR("2021-01-01","2021-03-31")
If the problem is still not resolved, please provide detailed error information, and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , This means there few dates missing in date table.
Also, the check dates do have a timestamp. if there is then create date like below and join with date table
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |