Forum Discussion
Create a table that records values every hour
Hello, I am seeking the help of the community for something I want to do in Power Query. I want to create a new table that calculates every day, a value and store it in a new table. Ideally th...
as your description, had better resovle it in DAX
say,
1 create a datetable, and mark it as date table
2 creat a relationships with date columns between the datetable and your data table
3 put the date column of datetable in the row area of a matrix visual
4 create two measure, and put them in the value area
TicketsCreated=COUNTROWS(FILTER(DataTable,DataTable[Status]="Created"))
TicketsResovled=COUNTROWS(FILTER(DataTable,DataTable[Status]="Resolved"))