Add daily fixed cost to table

[kca]

Hi

I dynamicaly get cost data from Azure that have multiple rows per day with various products/cost. 

Now I want to add the cost of a 3.part product that we pay monthly (e.g. 300$), so i can use it in my visuals.

What is the best way to add a new daily row into to the Azure table with a cost of 10$ (300$/30 days)?

Thanks

Kim

[amitchandak]

@kca , Create a date table with

Date = calendar(Date(2020,1,1),Today())

Avg Cost = 10 //new column

[kca]

Thanks.

What if I have multiple rows to add per day? like

ProductA 10$

ProductB 5$

[v-kelly-msft]

Hi @kca ，

Check whether below reference help:

https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[kca]

hi @v-kelly-msft 

Seems like a bit overkill for adding a few rows.