Forum Discussion

antarizana's avatar
antarizana
Frequent Visitor
1 year ago
Solved

Function DATESINPERIOD doesn't work properly

In POWER BI, I have imported general ledger with account, amounts, and dates (the date is always the last day of the month). The amounts for income and expense accounts are cumulative-the data on the...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi antarizana 
    I really sorry for the confusion here is the refined DAX that will help you to resolve our issue.
    If you still need facing anu issues please share the sample data so that i can help you address your requiement.
    Updated DAX 
    Rolling12Months =
    VAR __SelectedDate = MAX('Date'[Date])
    VAR __StartDate = EDATE(__SelectedDate, -11) // includes 12 months
    RETURN
    CALCULATE(
    SUM(YourTable[Amount]),
    DATESBETWEEN(
    'Date'[Date],
    __StartDate,
    __SelectedDate
    )
    )

    If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
    Best Regards,
    Community Support Team _ C Srikanth.


v-csrikanth's avatar
v-csrikanth
Community Support
1 year ago

Hi antarizana 
I sincerely appreciate the time and effort you have taken to resolve your issue and share your findings.
We kindly request you to mark your response as the Accept as a Solution that is helful for the other community members faces similar issue.

Thanks and Regards,
Cheri Srikanth 
Community Support Team

antarizana's avatar
antarizana
Frequent Visitor
1 year ago

v-csrikanth 

Sorry for the late reply, but clearly there has been some misunderstanding.
I haven't solved the problem, and formulas you suggested don't work well. I asked you to try getting the desired result with a simple example...

Honestly, I think this is an unsolved problem, and I am giving up on creating the rolling sum.

Thank you to everyone who tried to help me.

Best regards.