Forum Discussion
Power ParticipantSmall discrepancies in Total YTD using same measure
I'm not sure whats happening either, I inherited this beast of a datamodel over 2 yrs ago. I have so many date columns in my main fact table, as soon as i try to create inactive relationships like you suggest the entire report breaks down. Everything was built on the Created On date > Date2.Date field.
Anyway, I've split the visual into two and started again - my numbers in black add up to 5,017 and are correct now.Thanks for your help, much appreciated...
Power ParticipantI'm not sure whats happening either, I inherited this beast of a datamodel over 2 yrs ago. I have so many date columns in my main fact table, as soon as i try to create inactive relationships like you suggest the entire report breaks down. Everything was built on the Created On date > Date2.Date field.
Anyway, I've split the visual into two and started again - my numbers in black add up to 5,017 and are correct now.
Thanks for your help, much appreciated...
Hi, ArchStanton
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.