Forum Discussion

cgil's avatar
cgil
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Last value in a month

Hi all!   I need some help. I have 3 columns in a summarize table (Provincia, Mes(month of the date of the main table, Total). For each Mes(it is the month of a Date) I have sevaral values for th...
last value
  • cgil's avatar
    cgil
    4 years ago

    Hi all! In the end I solved it using Power M Query, I created a table with this 3 columns I need, then I sort them by the date and I add an index. 

    After that I used this formula in DAX: 

    if(COUNT(Consulta1[Fecha]) = 1, SUM(Consulta1[Total]), CALCULATE(SUM(Consulta1[Total]), FILTER(Consulta1, Consulta1[Índice] = max(Consulta1[Índice] ))))
     
    THanks for your help!
cgil's avatar
cgil
Icon for Advocate I rankAdvocate I
4 years ago

Hi all! In the end I solved it using Power M Query, I created a table with this 3 columns I need, then I sort them by the date and I add an index. 

After that I used this formula in DAX: 

if(COUNT(Consulta1[Fecha]) = 1, SUM(Consulta1[Total]), CALCULATE(SUM(Consulta1[Total]), FILTER(Consulta1, Consulta1[Índice] = max(Consulta1[Índice] ))))
 
THanks for your help!