Custom date table to pull data from other table on the daily basis

[jibran]

Hi,

I am creating a report for our operations department where we want to create our own custom table that has daily date field and pull data from other table on the daily basis.

I want to create above table that has incremental date and No.of Quotes, Save etc it will pull up on daily basis from the other table that is main table has data like this 

Date Created	Quote No	Company	Created By	Description	Status
04/06/2017	121	Vehicle Management	User 1		Saved
04/06/2017	122	RYF Solutions	User 2		Saved
04/06/2017	123	ABC	User 3		Saved
06/06/2017	124	Taxi Hire	User 1		Converted
07/06/2017	125	Fleet	User 5		Converted
07/06/2017	126	Management Solutions	User 6		Converted
08/06/2017	127	ABC	User 3		Saved
08/06/2017	128	Fleet	User 8		Saved

So for example on above table I've three quotes on 4th June 2017 the custom table against the 04/06/2017 would display under Save 3, against 06/06/2017 1 etc.

Can someone point me to the right direction, I shall be very thankful to you?

[v-haibl-msft · Accepted solution]

@jibran

You can try to create a summarize table with following formula.

Table = 
SUMMARIZECOLUMNS (
    Table1[Date Created],
    "No. of quotes", CALCULATE ( DISTINCTCOUNT ( Table1[Quote No] ) ),
    "Save", CALCULATE ( COUNTROWS ( Table1 ), Table1[Status] = "Saved" )
        + 0,
    "Conversion", CALCULATE ( COUNTROWS ( Table1 ), Table1[Status] = "Converted" )
        + 0
)

Best Regards,

Herbert

[jibran]

Hi,

I would like to give you kudos,

How can I give that 

Really amazing work 

Thanks alot