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
    4 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:

     

Anonymous's avatar
Anonymous
Not applicable
4 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: