Apply DateAdd in Measures

[jdelekta]

Hello,

Please see attached. I am trying to calculate total defections over the last 3 months and total items that were not defects over the last 6 months. I'd ultimately like to divide these and show the changes each month. I created conditional columns in the data set to count the defects ("Defect Count") and everything else in the data ("Not Defect Count"). 

I've been using DateAdd but haven't had success. I've noticed that when I go further back in time I end up getting less results.

The expected result would be for "Defects Last 3 Months" would be 5 and for "Created Last 6 Months" would be 24. I am assuming it is something with the relationship.

Thank you. 

[jdelekta]

@Greg_Deckler I just uploaded some screen shots. Thank you!

[Greg_Deckler]

@jdelekta Will be far easier to troubleshoot if you share your PBIX via OneDrive, Box, etc.

[jdelekta]

@Greg_Deckler I uploaded it with this link https://1drv.ms/u/s!Arv4FwjDD7PXb50-qLKbx3sj2D0?e=1V7TgI thanks!

[jdelekta]

@Greg_Deckler I wanted to see if you had any thoughts on the attached? I assume its related to the relationship that I created and I've been trying to adjust without any luck. Thanks!

[Greg_Deckler]

@jdelekta Don't see an attachment. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[jdelekta]

I didn't realize I couldn't upload a pbix file. Please see screen shots below.