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).
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 Thank you Sir, you are correct. I have just made normal Date table as easily getting information online, and this cause average values only time 00:00:00. So i have tried rebuild my date table which has hours and minuites than i could get matched value. Thanks Greg again!