Forum Discussion
What Happens when you sum datediff?
Hi I am reviewing an old PowerBi report I am redoing and believe that the numbers produce are incorrect. However, before I call them incorrect I wanted to understand what happens if you sum dat...
Hi HankScorpio2 ,
Is the Create to Lodge a Measure or a column? Asking this because the context for measures is different from the one in Columns.
In this case if you are using a column and you have 3 lines with the date of January 14 then you will get the 10 (datediff) * 3 rows. this error will then persist on your average.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.