Is there any wrong with my measure formular?

[trang_000]

I have a measure below:

DEBIT NOTE B4 = SUMX('table', 'table'[Due Date] - 29)

When I use measure in Report View, only 1 transaction is incorrect

When i changed the formular for that measure to

DATEADD('table'[Due Date], -29, DAY)

or 

CALCULATE(
    SUMX(
        'table',
        DATEADD('table'[Due Date], -29, DAY)
    )
)

All results are null.

Please advise me if any wrong with formular or anything else.

Thank you!

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like or how the filter context is configured, but please try something like below whether it works.

DEBIT NOTE B4 =
MAX ( 'table'[Due Date] ) - 29

[trang_000]

Thank you for your feedback,

I added a New Column = Due Date - 29 then it works now.

[v-dineshya]

Hi @trang_000  ,

Thanks for the update. We are happy to hear that you have resolved the issue. Thanks for sharing the details here. Please mark your insights 'Accept as solution' to help others with similar problems find it easily. 
Thank you.

[v-dineshya]

Hi @trang_000  ,

Thanks for the update. We are happy to hear that you have resolved the issue. Thanks for sharing the details here. Please mark your insights 'Accept as solution' to help others with similar problems find it easily. 
Thank you.

[v-dineshya]

Hi @trang_000  ,

Thanks for the update. We are happy to hear that you have resolved the issue. Thanks for sharing the details here. Please mark your insights 'Accept as solution' to help others with similar problems find it easily. 
Thank you.

[v-dineshya]

Hi @trang_000  ,

Thanks for the update. We are happy to hear that you have resolved the issue. Thanks for sharing the details here. Please mark your insights 'Accept as solution' to help others with similar problems find it easily. 
Thank you.

[v-dineshya]

Hi @trang_000 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.In case we do not receive a response, we shall proceed to close this thread. For any further discussions or queries, please initiate a new thread in the Microsoft Fabric Community Forum, where we will be glad to assist you.

Thank you.