Forum Discussion
Day difference in some rows wrong
Hello experts, I have never seen this before. I created some day diff calculation and noticed in about 20 rows (among thousands) the value is wrong. I tried both calculated column and measure. Both s...
- Update,
Found the problem. The rows where day diff was coming wrong, data in database were wrong like 01032013 became 01033013. As data was formatted as 03-Jan-13 in both database and PBI, it went unnoticed.
Thanks to all for helping me.
Anonymous Can you provide a sample dataset with rows having issues?