Nrthugu

CP Boötis From Wikipedia, the free encyclopedia Jump to navigation Jump to search CP Boötis Observation data Epoch J2000      Equinox J2000 Constellation Boötes Right ascension 14 h  33 m  20.26330 s [1] Declination +36° 57′ 32.4483″ [1] Apparent magnitude  (V) 6.40 [2] Characteristics Evolutionary stage subgiant [3] Spectral type F8 IVw [4] U−B color index 0.07 [2] B−V color index 0.51 [2] Variable type δ Sct [5] Astrometry Radial velocity (R v ) +5.9 [6]  km/s Proper motion (μ) RA:  +2.694 [1]  mas/yr Dec.:  −73.096 [1]  mas/yr Parallax (π) 12.9135 ± 0.0244 [1]  mas Distance 252.6 ± 0.5 ly (77.4 ± 0.1 pc) Absolute magnitude  (M V ) 2.05 [2] Details Mass 1.77 [6]   M ☉ Luminosity 7001120000000000000♠ 12.0 +1.5 −1.3 [7]   L ☉ Surface gravity (log  g ) 3.67 [6]  cgs Temperature 6,276 [6]  K Metallicity

1 1 I want to calculate the annual average of sales by quarter in Power Bi. I usually solve this in Excel with an Averageif between dates (last date of a quarter and same date one year earlier). Below a sample of my data: Date Quarter Sale 1/12/2016 2016-Q1 12.5 2/25/2016 2016-Q1 65.1 4/7/2016 2016-Q2 95.5 6/22/2016 2016-Q2 74.5 7/10/2016 2016-Q3 7.3 8/30/2016 2016-Q3 87.6 9/5/2016 2016-Q3 88.4 10/27/2016 2016-Q4 18 11/12/2016 2016-Q4 64.2 12/29/2016 2016-Q4 37.2 1/28/2017 2017-Q1 17.8 3/8/2017 2017-Q1 59.6 4/16/2017 2017-Q2 68.7 6/15/2017 2017-Q2 68.5 7/20/2017 2017-Q3 61.8 8/7/2017 2017-Q3 10.8 9/23/2017 2017-Q3 26.5 10/7/2017 2017-Q4 49.8 11/26/2017 2017-Q4 79.7 12/3/2017 2017-Q4 80.5 1/18/2018 2018-Q1 12.5 3/19/2018 2018-Q1 54.7 4/12/2018 2