Forum Discussion
Solved
Date table connection cause wrong average calculation
Hi All, I am newbie for power bi, and stuck in trouble. My data is based on time stamp (every 15 mins), and values from sensors as like below. When i put value just on Card, and select av...
ohjjang So does you Date table contain just dates or dates and timestamps? The issue with just Dates in your case is that these will not match up with dates other than timestamps of 00:00:00 (midnight).
Greg_Deckler
Community Champion
Community Championohjjang My guess, and this is only a guess, is that setting the slicer sets the end time to be the date and 0 time (midnight) and thus excludes an entire day's worth of data?