Subtracting days form date

Hi Steve, thank you but this didnt work. I get an error stating that the column gow time doesnt exist or there is a relationship missing. I did create the relationship, but it is not beeing picket up in the function.

I have attached the pbix, I hope you don't mind thinking a look.

https://drive.google.com/file/d/1uZFHig9Jnv_6R1n1EONixlZ8UNBZbciF/view?usp=sharing 

Hey cocoloco79 . The relationship you had was many-to-many which is problematic. I updated your .pbix and it is linked here. 

This was the relationship in your file:

I use this code to create a bridge table:

Grow Times = ALL( BI_Planting_Master[CropName], BI_Planting_Master[CropGrowTime])

And then updated the relationships:

And then updated the fields in the table visual:

Someone else may have a better way to do this.. but this is they way I know. Hope that works for you!

-Steve

Hi,

You may download my PBI file from here.

Hope this helps.