Forum Discussion

Noah's avatar
Noah
Regular Visitor
1 year ago
Solved

Multiple Date Columns and USERELATIONSHIP

Hello, everyone!   I am currently helping out my spouse with a Power BI dashboard for her work. She has a table that she cannot modify the columns of due to rules restrictions.   I've made and sh...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    Noah I would probably go with a disconnected (unrelated) date table and then form the relationship in a measure checking first for Date completed but if BLANK, check a different date.

     

    You might be able to use USERELATIONSHIP. You would need to form relationships between your date table and all the date columns in the table with the active relationship being Date Completed. Would be a simplar process of checking of Date Completed is blank and then using CALCULATE with USERELATIONSHIP. 

     

    IMHO, the first approach is going to be easier to do and debug.

v-csrikanth's avatar
v-csrikanth
Community Support
1 year ago

Hi Noah 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.