Forum Discussion
TejasShah
Helper I
2 years agoAdd manual measure with already existing data for a Line graph chart
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 ...
- 2 years ago
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:
TejasShah
Helper I
2 years agoDataNinja777 thank you so much for your support, I was really useful. I could get the output which was required. Thanks, once again!