Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have been trying to add a new column to my model that contains dates that are five days after my due date column.
I have been abe to create the new column, and the dates are corect, but when I try to add it ti may visual (Table) I keep getting the error message "Relationship or measure is not in a valid state"
I used this DAX =DATEADD(Due_Date, 7, DAY) and = ([Due_date] + 5) both created the new column, wth correct dates but I cannot add the variable to my visuals.
All other variables, relationships, and measures are working fine accross the model.
Any thoughts?
Solved! Go to Solution.
Thanks for your help @Ritaf1983 ,
I found a solution. I had to create a date hierarchy for the new calculated date column, then it worked without the error.
Hi @Disaster110
This is something strange in your formula with "and"...
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Sorry, my mistake, I meant to say -
I used both of these formulae seperately and both worked to create the column -
First DAX formula =DATEADD(Due_Date, 5, DAY)
Second DAX formula = ([Due_date] + 5
Will post sample data shortly 🙂
Scratch that, My organisation will not let me share or post any of the data as it contains sensative info that cant be scrubbed.
Here is a screen shot of the error message if it helps -
Hi @Disaster110
I don't need your real data, I just need some sample table to use to understand what data you have and what is the desired result...
Task_CodeDue_DateFormatted_Application_NumberFormatted_LocationColumn1
|
Thanks for your help @Ritaf1983 ,
I found a solution. I had to create a date hierarchy for the new calculated date column, then it worked without the error.