Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table with daily data from monthly information

I need to create the following table: Date \ ID \ Daily Target 01/01/22 \ ID1 \ 3658 01/01/22 \ ID2 \ 8459 13/03/22 \ ID1 \3000 I already have a date table that I create with DAX and a que...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I finally find a solution:
    Add a new column:
    Table.AddColumn(#"Columnas con nombre cambiado2", "Personalizado", each List.Dates([Month], Date.Day(Date.EndOfMonth([Month])), #duration(1, 0, 0, 0)))

     

     



    Then Expand:

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

Anonymous 

you can try this to create the month-year column

Column = FORMAT('Table'[Date],"mmmm")&"-"&year('Table'[Date])