Forum Discussion

AOPOLO's avatar
AOPOLO
New Member
4 years ago

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?

 

 

 

Data Protection

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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-power-bi

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.