Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
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
Hi,
I would like to give you kudos,
How can I give that
Really amazing work
Thanks alot
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |