Compare period performance based on filter selection

Question

Hi there,&nbsp;I'm trying to compare period performance of milestones achieved - using a filter to select the periods i want to review - there will only ever be two periods of review and ideally this will be current month vs filter selection.&nbsp;Below is an example of my data.&nbsp;&nbsp;For example with Reporting Period 2019-01 and 2019-2 selected the graphic will show Jan-19 as -1 and Feb-19 as +1 becasue in 2019-01 three milestones were to be acheived in Jan-19 however in 2019-02 the forecast is two in Jan-19 and one in Feb-19.&nbsp;This variance and movement will then be shown on a bar chart. Period on X axis and movement on the Y.&nbsp;I hope the above is clear and thank you for you help, much appreciated.&nbsp;&nbsp;Sam&nbsp;

v-danhe-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
From your description, I could not understand your logic about below word:
Spoiler (Highlight to read)For example with Reporting Period 2019-01 and 2019-2 selected the graphic will show Jan-19 as -1 and Feb-19 as +1 becasue in 2019-01 three milestones were to be acheived in Jan-19 however in 2019-02 the forecast is two in Jan-19 and one in Feb-19For example with Reporting Period 2019-01 and 2019-2 selected the graphic will show Jan-19 as -1 and Feb-19 as +1 becasue in 2019-01 three milestones were to be acheived in Jan-19 however in 2019-02 the forecast is two in Jan-19 and one in Feb-19
If all reporting period is same with Date, it will be -1? And only one reporting period (2019-02,Z,Z-1,Contract sign,2019/2/1) is same with Date will show +1?
&nbsp;
Regards,
Daniel He

Forum Discussion

Related content

Comparing activity performance

Fabric Performance Issue During GCP to Azure Migration: SELECT * from Views Hanging on F128 Capacity

Compare Fabric DW and Azure SQL performance

DAX Performance

DAX performance optimization