Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AOPOLO
New Member

NEW Date Data Messing up Current DAX

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?

 

 

 

2 REPLIES 2
v-yadongf-msft
Community Support
Community Support

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
Super User
Super User

@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...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors