Forum Discussion

ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago
Solved

Add column to new table

Hi again, I have a table (Report Diario) with the next columns:   AGREEMENT DATE END DATE AMOUNT REGION   In a new table (CalendarioAdelantado) I have the next columns: DATE AMOUNT ...
Need Help
  • ZunzunUOC's avatar
    ZunzunUOC
    7 years ago

    Finally, here the solution:

     

    Table = SELECTCOLUMNS(FILTER(CROSSJOIN(CALENDAR("01/01/2018";"01/01/2020");'Report Diario');[Date]>='Report Diario'[Fecha de Cierre]&&[Date]<='Report Diario'[Fecha Comprometida] && NOT(ISBLANK('Report Diario'[Fecha de Cierre])));"FECHA";[Date];"REGION";'Report Diario'[Sales Region];"ADELANTADO";'Report Diario'[Signed Monthly Billing In Local Currency])

    I found it in another forum. Thanks.

ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

Hi v-frfei-msft , thanks for your effort.

 

I going to try to explaing better:

 

I have the next table:

 

 

And I need to show the next:

 

 

In every day I have between, agreement and end-Date, I need to show a data per region.

 

ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

Finally, here the solution:

 

Table = SELECTCOLUMNS(FILTER(CROSSJOIN(CALENDAR("01/01/2018";"01/01/2020");'Report Diario');[Date]>='Report Diario'[Fecha de Cierre]&&[Date]<='Report Diario'[Fecha Comprometida] && NOT(ISBLANK('Report Diario'[Fecha de Cierre])));"FECHA";[Date];"REGION";'Report Diario'[Sales Region];"ADELANTADO";'Report Diario'[Signed Monthly Billing In Local Currency])

I found it in another forum. Thanks.