Forum Discussion

TejasShah's avatar
TejasShah
Icon for Helper I rankHelper I
2 years ago
Solved

Add 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 ...
  • DataNinja777's avatar
    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: