Forum Discussion
Total YTD does not work
Thanks for the suggestion. I got the same result. It is not working.
Any other ideas?
Anonymous ,
What i understand from your visual is taht Report Date is not part of the Date Table.
You need to pull the Date from the Date table in the visualization.
Regards,
HN
Can you share your model and some sample date in text format.
- Anonymous6 years agoNot applicable
It appears what is happening is Power BI is not letting 2 different Date relationship from 2 seperate table to exist in one YTD calculation.
Does that make sense?
- Anonymous6 years agoNot applicable
Anonymous ,
You will need to use USERELATIONSHIP
https://www.youtube.com/watch?v=LfVDUiU8vaU
https://radacad.com/datesinperiod-vs-datesbetween-dax-time-intelligence-for-power-bi
https://radacad.com/building-a-virtual-relationship-in-power-bi-basics-of-treatas-dax-function
Regards,
HN