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
Icon for Community Support rankCommunity Support
1 year ago

Hi Noah 

Thank you for being part of the Microsoft Fabric Community.

As highlighted by Greg_Deckler , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Best Regards,
Cheri Srikanth.