Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a data table where I am getting daily data of Date and serial No
Date | Serial No. |
29-01-2024 | ABC1 |
29-01-2024 | ABC2 |
29-01-2024 | ABC3 |
29-01-2024 | ABC4 |
29-01-2024 | ABC5 |
30-01-2024 | ABC6 |
30-01-2024 | ABC7 |
31-01-2024 | ABC8 |
31-01-2024 | ABC9 |
31-01-2024 | ABC10 |
31-01-2024 | ABC11 |
01-02-2024 | ABC12 |
01-02-2024 | ABC13 |
02-02-2024 | ABC14 |
02-02-2024 | ABC15 |
02-02-2024 | ABC16 |
02-02-2024 | ABC17 |
03-02-2024 | ABC18 |
03-02-2024 | ABC19 |
04-02-2024 | ABC20 |
05-02-2024 | ABC21 |
05-02-2024 | ABC22 |
05-02-2024 | ABC23 |
06-02-2024 | ABC24 |
06-02-2024 | ABC25 |
06-02-2024 | ABC26 |
06-02-2024 | ABC27 |
06-02-2024 | ABC28 |
07-02-2024 | ABC29 |
07-02-2024 | ABC30 |
08-02-2024 | ABC31 |
09-02-2024 | ABC32 |
10-02-2024 | ABC33 |
10-02-2024 | ABC34 |
10-02-2024 | ABC35 |
10-02-2024 | ABC36 |
11-02-2024 | ABC37 |
12-02-2024 | ABC38 |
12-02-2024 | ABC39 |
12-02-2024 | ABC40 |
13-02-2024 | ABC41 |
14-02-2024 | ABC42 |
15-02-2024 | ABC43 |
16-02-2024 | ABC44 |
16-02-2024 | ABC45 |
17-02-2024 | ABC46 |
17-02-2024 | ABC47 |
17-02-2024 | ABC48 |
17-02-2024 | ABC49 |
18-02-2024 | ABC50 |
19-02-2024 | ABC51 |
20-02-2024 | ABC52 |
21-02-2024 | ABC53 |
21-02-2024 | ABC54 |
21-02-2024 | ABC55 |
21-02-2024 | ABC56 |
21-02-2024 | ABC57 |
21-02-2024 | ABC58 |
22-02-2024 | ABC59 |
22-02-2024 | ABC60 |
22-02-2024 | ABC61 |
23-02-2024 | ABC62 |
24-02-2024 | ABC63 |
24-02-2024 | ABC64 |
24-02-2024 | ABC65 |
24-02-2024 | ABC66 |
24-02-2024 | ABC67 |
24-02-2024 | ABC68 |
24-02-2024 | ABC69 |
25-02-2024 | ABC70 |
25-02-2024 | ABC71 |
25-02-2024 | ABC72 |
25-02-2024 | ABC73 |
26-02-2024 | ABC74 |
27-02-2024 | ABC75 |
28-02-2024 | ABC76 |
28-02-2024 | ABC77 |
28-02-2024 | ABC78 |
28-02-2024 | ABC79 |
29-02-2024 | ABC80 |
01-03-2024 | ABC81 |
01-03-2024 | ABC82 |
01-03-2024 | ABC83 |
01-03-2024 | ABC84 |
01-03-2024 | ABC85 |
01-03-2024 | ABC86 |
01-03-2024 | ABC87 |
01-03-2024 | ABC88 |
01-03-2024 | ABC89 |
01-03-2024 | ABC90 |
01-03-2024 | ABC91 |
02-03-2024 | ABC92 |
02-03-2024 | ABC93 |
02-03-2024 | ABC94 |
02-03-2024 | ABC95 |
02-03-2024 | ABC96 |
02-03-2024 | ABC97 |
02-03-2024 | ABC98 |
03-03-2024 | ABC99 |
04-03-2024 | ABC100 |
04-03-2024 | ABC101 |
05-03-2024 | ABC102 |
05-03-2024 | ABC103 |
05-03-2024 | ABC104 |
05-03-2024 | ABC105 |
05-03-2024 | ABC106 |
05-03-2024 | ABC107 |
05-03-2024 | ABC108 |
05-03-2024 | ABC109 |
05-03-2024 | ABC110 |
06-03-2024 | ABC111 |
06-03-2024 | ABC112 |
06-03-2024 | ABC113 |
06-03-2024 | ABC114 |
06-03-2024 | ABC115 |
06-03-2024 | ABC116 |
06-03-2024 | ABC117 |
07-03-2024 | ABC118 |
07-03-2024 | ABC119 |
07-03-2024 | ABC120 |
08-03-2024 | ABC121 |
09-03-2024 | ABC122 |
10-03-2024 | ABC123 |
10-03-2024 | ABC124 |
10-03-2024 | ABC125 |
10-03-2024 | ABC126 |
10-03-2024 | ABC127 |
10-03-2024 | ABC128 |
10-03-2024 | ABC129 |
10-03-2024 | ABC130 |
10-03-2024 | ABC131 |
11-03-2024 | ABC132 |
11-03-2024 | ABC133 |
12-03-2024 | ABC134 |
13-03-2024 | ABC135 |
14-03-2024 | ABC136 |
14-03-2024 | ABC137 |
14-03-2024 | ABC138 |
14-03-2024 | ABC139 |
14-03-2024 | ABC140 |
15-03-2024 | ABC141 |
15-03-2024 | ABC142 |
16-03-2024 | ABC143 |
17-03-2024 | ABC144 |
17-03-2024 | ABC145 |
17-03-2024 | ABC146 |
18-03-2024 | ABC147 |
18-03-2024 | ABC148 |
19-03-2024 | ABC149 |
20-03-2024 | ABC150 |
20-03-2024 | ABC151 |
20-03-2024 | ABC152 |
20-03-2024 | ABC153 |
20-03-2024 | ABC154 |
20-03-2024 | ABC155 |
20-03-2024 | ABC156 |
20-03-2024 | ABC157 |
20-03-2024 | ABC158 |
20-03-2024 | ABC159 |
20-03-2024 | ABC160 |
21-03-2024 | ABC161 |
21-03-2024 | ABC162 |
21-03-2024 | ABC163 |
21-03-2024 | ABC164 |
22-03-2024 | ABC165 |
22-03-2024 | ABC166 |
22-03-2024 | ABC167 |
22-03-2024 | ABC168 |
22-03-2024 | ABC169 |
22-03-2024 | ABC170 |
22-03-2024 | ABC171 |
22-03-2024 | ABC172 |
22-03-2024 | ABC173 |
22-03-2024 | ABC174 |
22-03-2024 | ABC175 |
23-03-2024 | ABC176 |
23-03-2024 | ABC177 |
23-03-2024 | ABC178 |
23-03-2024 | ABC179 |
24-03-2024 | ABC180 |
24-03-2024 | ABC181 |
24-03-2024 | ABC182 |
24-03-2024 | ABC183 |
24-03-2024 | ABC184 |
24-03-2024 | ABC185 |
24-03-2024 | ABC186 |
25-03-2024 | ABC187 |
25-03-2024 | ABC188 |
25-03-2024 | ABC189 |
25-03-2024 | ABC190 |
25-03-2024 | ABC191 |
25-03-2024 | ABC192 |
26-03-2024 | ABC193 |
26-03-2024 | ABC194 |
26-03-2024 | ABC195 |
27-03-2024 | ABC196 |
28-03-2024 | ABC197 |
28-03-2024 | ABC198 |
28-03-2024 | ABC199 |
28-03-2024 | ABC200 |
28-03-2024 | ABC201 |
29-03-2024 | ABC202 |
29-03-2024 | ABC203 |
29-03-2024 | ABC204 |
30-03-2024 | ABC205 |
30-03-2024 | ABC206 |
30-03-2024 | ABC207 |
30-03-2024 | ABC208 |
30-03-2024 | ABC209 |
30-03-2024 | ABC210 |
30-03-2024 | ABC211 |
31-03-2024 | ABC212 |
31-03-2024 | ABC213 |
31-03-2024 | ABC214 |
31-03-2024 | ABC215 |
31-03-2024 | ABC216 |
31-03-2024 | ABC217 |
31-03-2024 | ABC218 |
31-03-2024 | ABC219 |
31-03-2024 | ABC220 |
31-03-2024 | ABC221 |
Now that when I plot this data of Month Vs Sum of Distinct Count of Serial No, I get proper plots for February, March, April but since my DB table was created in late January, I do not have data of January to plot.
I have the total for the month of January, how can I merge my January month total along with remaining month's plot of the year.
Here the yellow line showcases target line, while the blue one is the Sum of Distinct Count of Serial nos. for that particular month.
Solved! Go to Solution.
Hi @TejasShah ,
You can get your required output by adding the measure of total January prior to implementation of serial number database. Even if you don't have the data with same granularity, you can add in a measure the January total transactions. You can replace the yellow highlighted hard-coded number with your January total measure prior to implementation fo the serial number database.
I attach an example pbix file below:
@DataNinja777 thank you so much for your support, I was really useful. I could get the output which was required. Thanks, once again!
Hi @TejasShah ,
You can get your required output by adding the measure of total January prior to implementation of serial number database. Even if you don't have the data with same granularity, you can add in a measure the January total transactions. You can replace the yellow highlighted hard-coded number with your January total measure prior to implementation fo the serial number database.
I attach an example pbix file below:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |