Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated column with DATEADD

Hi, new to Power BI.  I'm trying to create a Prior day measure and current day measure to calculate the difference in records processed (num_processed) in my data table over distinct events day over ...
Need Help
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago
Anonymous Thanks for that, but it wasn't clean to copy and paste the data (As it is loosing its alignment when coping it as is). Could you please post the same in proper copiable format.
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm not sure how to copy it so that you can see it in this forum from BI.  Suggestions ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Data I posted,  you could copy to excel and parse.  Any suggestion would be welcome. Thanks so much for your help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      generated_idinstanceeffective_datesrc_intfc_instFeed Typereceipt_datestatus_flagstart_dateend_datetrimmed_end_datenum_processednum_failednum_warningsnum_fatalserror_typesched_def_instsched_queue_inststar_batch_idRun Datedata_source_path
      150342911/5/2018 0:0042SM211/5/2018 0:30Y11/5/2018 0:3011/5/2018 0:3311/5/2018 0:00255000X39518280829 11/5/2018 0:00ISGFileShare\CFDS\trigger_scd_idx_opt.txt
      350343111/5/2018 0:00123IOP11/5/2018 0:54Y11/5/2018 0:5411/5/2018 0:5411/5/2018 0:00297000X34665280831 11/5/2018 0:00ISGFileShare\CFDS\IndexOptions_Price.txt
      450343211/5/2018 0:0042FIB11/5/2018 1:50Y11/5/2018 1:5011/5/2018 1:5011/5/2018 0:0015000X41182280832 11/5/2018 0:00ISGFileShare\CFDS\trigger_scd_fi_bm.txt
      550343311/5/2018 0:0042CPA11/5/2018 2:01Y11/5/2018 2:0111/5/2018 2:0111/5/2018 0:004374000X34521280833 11/5/2018 0:00ISGFileShare\CFDS\trigger_prp_ca.txt
      650343411/5/2018 0:0042CPA11/5/2018 2:03Y11/5/2018 2:0311/5/2018 2:0311/5/2018 0:004374000X34521280834 11/5/2018 0:00ISGFileShare\CFDS\trigger_prp_ca.txt
      750343511/5/2018 0:0042CPA11/5/2018 2:04Y11/5/2018 2:0411/5/2018 2:0411/5/2018 0:004374000X34521280835 11/5/2018 0:00ISGFileShare\CFDS\trigger_prp_ca.txt
      850343611/5/2018 0:0042CPA11/5/2018 2:06Y11/5/2018 2:0611/5/2018 2:0611/5/2018 0:004374000X34521280836 11/5/2018 0:00ISGFileShare\CFDS\trigger_prp_ca.txt
      950343711/5/2018 0:0042CPA11/5/2018 2:08Y11/5/2018 2:0811/5/2018 2:0811/5/2018 0:004374000X34521280837 11/5/2018 0:00ISGFileShare\CFDS\trigger_prp_ca.txt
      1150343911/5/2018 0:0042CPA11/5/2018 2:21Y11/5/2018 2:2111/5/2018 2:2111/5/2018 0:0033000 34522280839 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\Bloomberg\CPA1\prp_ca.txt_20181105022115.20181105
      1250344011/5/2018 0:00123DIV11/5/2018 2:21Y11/5/2018 2:2111/5/2018 2:2111/5/2018 0:00131000X34523280840 11/5/2018 0:00ISGFileShare\CFDS\pace_div.txt
      1350344111/5/2018 0:00123SPL11/5/2018 2:21Y11/5/2018 2:2111/5/2018 2:2111/5/2018 0:001000X34524280841 11/5/2018 0:00ISGFileShare\CFDS\pace_spl.txt
      1450344211/5/2018 0:00110TCD11/5/2018 4:02Y11/5/2018 4:0311/5/2018 4:0411/5/2018 0:0063000 26682280842 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\MARKIT\TCD1\20181105040229__TrancheCDSPrices_20181102.csv
      1550344311/5/2018 0:00110TCD11/5/2018 4:02Y11/5/2018 4:0411/5/2018 4:0411/5/2018 0:000000 26682280842 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\MARKIT\TCD1\20181105040255__CITrancheCDSPrices_20181102.csv
      1650344411/5/2018 0:00123TCD11/5/2018 4:04Y11/5/2018 4:0411/5/2018 4:0411/5/2018 0:0013000X34674280843 11/5/2018 0:00ISGFileShare\CFDS\CDX_Tranche_Price.txt
      1750344511/5/2018 0:00123NPO11/5/2018 4:07Y11/5/2018 4:0711/5/2018 4:0711/5/2018 0:000000X39308280844 11/5/2018 0:00ISGFileShare\CFDS\NPO_Price.txt
      1850344611/5/2018 0:00221CMS11/5/2018 4:28Y11/5/2018 4:2911/5/2018 4:2911/5/2018 0:0013000 40271280845 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\BBBO\CMS1\20181105042834__bbpsrisk_cms.txt_20181105042859.20181105
      1950344711/5/2018 0:00123FAC11/5/2018 4:37Y11/5/2018 5:4211/5/2018 5:4211/5/2018 0:0010388000 34474280847 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\SIMCORP\FAC1\20181105043701__SCD_FAC_181102043659.txt
      2150344911/5/2018 0:00123POS11/5/2018 5:20Y11/5/2018 5:4211/5/2018 5:4711/5/2018 0:0032271000 34474280847 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\SIMCORP\POS1\20181105052015__SCD_POS_THIRD_011118052006.txt
      2250345011/5/2018 0:00123POS11/5/2018 5:28Y11/5/2018 5:4711/5/2018 5:5111/5/2018 0:0032390000 34474280847 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\SIMCORP\POS1\20181105052831__SCD_POS_THIRD_021118052825.txt
      2350345111/5/2018 0:00123ETY11/5/2018 5:30Y11/5/2018 5:4211/5/2018 5:4211/5/2018 0:00221000 34474280847 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\SIMCORP\ETY1\20181105052921__SCD_ETY_COL_051118052916.txt
      2550345311/5/2018 0:00123COL11/5/2018 5:40Y11/5/2018 6:0011/5/2018 6:0011/5/2018 0:001436000 34474280847 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\SIMCORP\COL1\20181105054024__SCD_COL_AGR021118054019.txt
      2650345411/5/2018 0:00123COL11/5/2018 5:40Y11/5/2018 6:0011/5/2018 6:0011/5/2018 0:001436000 34474280847 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\SIMCORP\COL1\20181105054026__SCD_COL_PMT021118054022.txt
      2750345511/5/2018 0:00110RDX11/5/2018 6:01Y11/5/2018 6:4711/5/2018 7:2611/5/2018 0:009635000 39889280853 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\MarkIT\RDX1\20181105060023__CDXCreditIndex_20181102.csv
      2850345611/5/2018 0:00110RDX11/5/2018 6:01Y11/5/2018 7:2611/5/2018 7:5911/5/2018 0:007543000 39889280853 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\MarkIT\RDX1\20181105060030__ITRAXXCreditIndex_20181102.csv
      2950345711/5/2018 0:00110VAL11/5/2018 6:01Y11/5/2018 6:0111/5/2018 6:0111/5/2018 0:00383000 39219280848 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\MARKIT\VAL1\Markit_CDS_Valuations_02Nov2018.csv
      3050345811/5/2018 0:00123PDA11/5/2018 6:05Y11/5/2018 6:0511/5/2018 6:1211/5/2018 0:0025490000X36109280849 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\Exporter Files\PPDA_11052018061227.txt
      3150345911/5/2018 0:00235DCB11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:0011000 41785280852 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCB1\20181105064536__DCMBalances_BAMLBalances_20181102_20181105064623.csv
      3250346011/5/2018 0:00235DCB11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:000000 41785280852 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCB1\20181105064537__DCMBalances_GSBalances_20181102_20181105064623.csv
      3350346111/5/2018 0:00235DCM11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:0016000 41784280850 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCM1\20181105064534__DCMPositions_BAMLTradeRegisterCDS_20181102_20181105064623.csv
      3450346211/5/2018 0:00235DCM11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:000000 41784280850 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCM1\20181105064534__DCMPositions_BAMLTradeRegisterIRS_20181102_20181105064623.csv
      3550346311/5/2018 0:00235DCM11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:000000 41784280850 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCM1\20181105064534__DCMPositions_GSOpenTrades_20181102_20181105064623.csv
      3650346411/5/2018 0:00235DCT11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:001000 41783280851 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCT1\20181105064534__DCMTradeActivity_BAMLCash_20181102_20181105064623.csv
      3750346511/5/2018 0:00235DCT11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:002000 41783280851 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCT1\20181105064535__DCMTradeActivity_BAMLTradeRecapCDS_20181102_20181105064623.csv
      3850346611/5/2018 0:00235DCT11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:000000 41783280851 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCT1\20181105064535__DCMTradeActivity_BAMLTradeRecapIRS_20181102_20181105064623.csv
      3950346711/5/2018 0:00235DCT11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:000000 41783280851 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCT1\20181105064536__DCMTradeActivity_GSTradeActivity_20181102_20181105064623.csv
      4050346811/5/2018 0:00235DCT11/5/2018 6:46Y11/5/2018 6:4611/5/2018 6:4611/5/2018 0:000000 41783280851 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\DCMRECON\DCT1\20181105064536__DCMTradeActivity_GS_journal_entries_20181102_20181105064623.csv
      4150346911/5/2018 0:009RTG11/5/2018 7:59Y11/5/2018 7:5911/5/2018 8:2311/5/2018 0:006000X32523280857 11/5/2018 0:00vpr1eagleapp01\EagleSystems\PACE\Server\Exporter Files\RTG_SP_11052018082349.txt
      4250347011/5/2018 0:0042CES11/5/2018 8:29Y11/5/2018 8:2911/5/2018 8:3011/5/2018 0:0011000X37008280858 11/5/2018 0:00ISGFileShare\CFDS\trigger_credit_securities.txt
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      reposted data, you should be able to easily copy now.  Thanks

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous,

         

        I'm a little confused about your requirement.

         

        Do you want to create calculated column or measure? 

         

        If it is convenient, could you share your desired output so that I can understand your logic better and get the solution.

         

        Best  Regards,

        Cherry