Forum Discussion

Thulasiram's avatar
Thulasiram
Icon for Helper II rankHelper II
2 years ago

To choose date

Dear all,  I have the following table visual.   the column "Bal minus credit" is created by a measure. I want the correspending date of the last negative value and would like to minus that date wit...
Need Help
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

hi Thulasiram create these two Measures and let me know if you encounter into any issues.


Find the last negative value date:

 

 

 

LastNegativeDate = 
CALCULATE(
    MAX('Table'[Date]),
    FILTER(
        'Table',
        'Table'[Bal minus credit] < 0
    )
)

 

 

 

Difference between the last negative date and the fixed date:

 

 

 

DateDifference = 
DATEDIFF(
    [LastNegativeDate],
    DATE(2024, 3, 31),
    DAY
)

 

 

 

 

Did I answer your question? If so, please mark my post as the solution! Your Kudos are much appreciated! Proud to be a Resolver II