How to add Date column to the table

[Anonymous]

Hi all,

I have a table:

Column1 Column2  (calculates a sum of issues for each squad per day)           

Squad1    Sum(issues1)

Squad2    Sum(issues2)

Squad3    Sum(issues3)

Is it possible to add Date column to change table to:

Date         Column1 Column2 (calculates a sum of issues for each squad per day)

1.1.2018   Squad1    Sum(issues1)

1.1.2018   Squad2    Sum(issues2)

1.1.2018   Squad3    Sum(issues3)        

2.1.2018   Squad1    Sum(issues4)

2.1.2018   Squad2    Sum(issues5)

2.1.2018   Squad3    Sum(issues6)

3.1.2018   Squad1    Sum(issues7)

3.1.2018   Squad2    Sum(issues8)

3.1.2018   Squad3    Sum(issues9)

and so on

Thank you for help! 🙂

[Gokul]

are you importing the data or manually entering the data ???

[Anonymous]

I have a separate table with data that is imported from jira via rest api.

And i have created a new table that need to include a calculated values for each squad per day.

In this new table squads are entered manually and sum values are calculated with a formula.

[Gokul]

Hit load ,data's will be loaded as table !!(it is for manual )

[Anonymous]

Sorry... by manually i ment that i have added squads manually.

I would like to power bi to add date values automatically. It will take to long time to add 7 rows for each day 🙂

[Gokul]

I dont understand ur motive but if u want to add date column (randomly) you can use calenderauto() -DAX  to generate date randomly

[Anonymous]

No, i dont want to add value randomly. 🙂

I have a table (table1) with about 3000 issues. Each issue has a fields: squad name, creation date, close date, story points and so on.

I need to calculate how much issues each squad has created per day and some other calculations, each calculation in separate column. For this purpose i need a new table (table2). This table should includes calculated values for each squad for each day of year.

We have 7 squads, it means that for e.g. 1.1.2018 i should have 7 rows. Each row will iclude calulated values for  one squad.

Right now i can only calculate avg values, because i have no idea how to add date column to the table2.

[v-danhe-msft]

Hi @Anonymous,

Could you please share some sample data to have a test and post your desired result if possible?

Regards,

Daniel He

[Anonymous]

Hi Daniel He,

Data from Jira via rest api (works fine, no changes needed.)
Task_id	Created	Squad	Closed
1	12.12.2018	Squad1	13.12.2019
2	12.12.2018	Squad1
3	13.12.2018	Squad2
New table to be created:
Date	Squad	New issues	Closed issues
12.12.2018	Squad1	2	0
	Squad2	0	0
13.12.2018	Squad1	0	1
	Squad2	1	0

I have created a new table for the squad1, the table calculates how mane issues were created and closed per day.

I can create separate tables for each squad, but i dont want to... I would like to have only one table.

Br,

Natalia