Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average with Datesbetween

Hi,
I have some unexpected values that I dont understand why they appear.

 

I calculate a daily value using average called D_1 Auction as below:

 

I also calculated a monthly average using my Dates Table called Fechas, and related to the table "Mibgas PVB"). I call this measure 

As expected, with a monthly context, both measures are equal, but in the second one, the total average appears without any date.

 

 Why this value appears and how can I get rid off it?


Thanks

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Solved using this measure:

    D_1 Auction Promedio = IF( [D_1 Auction]=BLANK(),BLANK(),
     CALCULATE(
        [D_1 Auction],
        DATESBETWEEN(Fechas[Dia],STARTOFMONTH(Fechas[Dia]),ENDOFMONTH(Fechas[Dia]))
    )
    )
     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Solved using this measure:

    D_1 Auction Promedio = IF( [D_1 Auction]=BLANK(),BLANK(),
     CALCULATE(
        [D_1 Auction],
        DATESBETWEEN(Fechas[Dia],STARTOFMONTH(Fechas[Dia]),ENDOFMONTH(Fechas[Dia]))
    )
    )