Forum Discussion
Total YTD does not work
I have a table which I use to override a SUM measurement. This works fine in overriding the Sum measurement. However when I apply DATESYTD function on this measurement, I get incorrect results. My mo...
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?
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