NEW Date Data Messing up Current DAX

[AOPOLO]

HI everyone,

I have a Fiscal Year to date DAX that works Great! When I upload a new Projection data set with a new date column. It is doing something to my Oringal DAX. The card now returns a Blank NUmber. If I filter for Today, the card will work but not as it did before. When i delete the Date Column in the new data set, it fixes the problem, so I know it has something to do with that. Any ideas?

[v-yadongf-msft]

Hi @AOPOLO ,

Sorry, I can't figure out what you need based on your existing description. Can you share with us some screenshots of your data(hiding sensitive information) and DAX formulas, and the results you expec?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AOPOLO , If you have two dates. Join both of them with the date table and then use userelationship to activate the inactive join

with active join sales date

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date]))

with inactive join create date

calculate( calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date])),DATESYTD('Date'[Date]))

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...