Forum Discussion

Elofy's avatar
Elofy
Regular Visitor
4 years ago
Solved

Static KPI Target Goal

I need to know how much Income I need to reach Break Even Point. I know the Break Even Point date will be June, and the Target Goal is based on the sum of the row of those monthly expenses from Janua...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hello:

    Can you try:

    Fin. Despesa Break Even = CALCULATE(
    SUM(Overview[Fin. Break Even]),
    DATESBETWEEN('Calendário'[Date], DATE(2022, 1, 1), DATE(2022, 6, 1))
    )
     
    I hope this answers to your satisfaction. Please mark as solution if ok with you. Thanks
Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hello:

Can you try:

Fin. Despesa Break Even = CALCULATE(
SUM(Overview[Fin. Break Even]),
DATESBETWEEN('Calendário'[Date], DATE(2022, 1, 1), DATE(2022, 6, 1))
)
 
I hope this answers to your satisfaction. Please mark as solution if ok with you. Thanks
Elofy's avatar
Elofy
Regular Visitor
4 years ago

I was using this format at first and changed to the one I posted, but I noticed it changes nothing.

 

Thanks anyway.

  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    Hi:

    Can you doublecheck? It seems to work fine. Here is an example with calculation laid out to match your scenario, just with different dates.

     

    Do you have your Date Table marked as date table and is it continuos? It would need to have a relationship to your Overview table.

     

    The reply for using DATESBETWEEN should work?

     

    Can you share an image of your model and any example data for the two tables in question?

     

    Thanks!

     

    • Elofy's avatar
      Elofy
      Regular Visitor
      4 years ago

      While creating a new project with fictional values to show you the problem, I figured out I was using the wrong "Date" column in the Trend Axis.

       

      Thank you very much!