Extracting data Multiple Columns from current period and previous period.

Question

I know this is possible point by point with measures however I'm looking for a more efficient method.&nbsp;I'm looking for a method to create a table drawing data from multiple columns with the ability to pull value totals from specific periods in the same table (see the table below).&nbsp;&nbsp;Current PeriodPrevious PeriodPeriod Last YearColumn 1CP1PP1LY1Column 2CP2PP2LY2Culumn 3CP3PP3LY3Column 4CP4PP4LY4&nbsp;Note that I'm happy to do this via measures or by creating separate columns for each period but I would like to find a measure or method that can be used on other data columns (I have seen it done but the method was sealed in black box style so I do not know how they performed it).&nbsp;ADDED&nbsp;To clarify, here is example data, I can't give real data in this case&nbsp;&nbsp;Column 1Column 2Column 301/01/2019798.621857.818.2901/02/20193875.351060.911372.8301/03/20192668.82913.883254.3401/04/20194606.963737.383214.9401/05/20191499.232000.9530.9501/06/20192851.454927.253552.9801/07/20192708.884513.483092.8401/08/20193863.064822.98261.5101/09/20193123.161869.863381.7701/10/20192470.373292.954851.9101/11/2019875.21407.113949.401/12/20193648.41394.414251.4101/01/20201883.553474.144148.6101/02/20203106.722306.762617.6201/03/20204333.57577.033459.6601/04/20202508.873815.853567.2101/05/20203192.023265.59504.3101/06/20202262.831413.51422.3701/07/20204845.291504.921815.1101/08/20203984.53770.02943.5601/09/20201816.412746.664392.301/10/20204790.293427.694489.0601/11/20204656.941781.5927.7701/12/20201617.622179.254970.5&nbsp;And this is the final table I want, note I want to be able to be able to do this for day, week, month and quarter.&nbsp;&nbsp;Current MonthPrevious MonthPrevious YearColumn 11617.624656.943648.4Column 22179.251781.591394.41Column 34970.527.774251.41&nbsp;&nbsp;

hotchilli · Answer

Can you provide some sample data please (not a picture)?&nbsp; ... and tell us what it is you want a little more clearly please.
&nbsp;
Perhaps you could point us to where you've seen it done -&gt; "I have seen it done&nbsp;"

amitchandak · Answer

IanCF , not very clear. If you need a dynamic measure approach, refer&nbsp;
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-patternhttps://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
&nbsp;
//using the tabular editor, more options&nbsp; https://www.youtube.com/watch?v=vlnx7QUVYME
&nbsp;
If case you need time intelligence, this period vs last period, etc
Power BI — Year on Year with or Without Time Intelligence https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38aPower BI — Qtr on Qtr with or Without Time Intelligence https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839Power BI — Month on Month with or Without Time Intelligence https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090ePower BI — Week on Week and WTD https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123Day Intelligence - Last day, last non continous day https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
&nbsp;
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Forum Discussion

Related content

Extract Data from sharepoint

Extract Value from previous date

Extract multiple text

Extract previous - undo

extract text using Multiple delimiters