https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-Revenue-over-Two-Date-Ranges-Using-inactive-calendar/m-p/3325928#M157486 <P>Hi,</P><P>&nbsp;</P><P>I am trying to compare revenue over two date ranges using an inactive calendar related to my active calendar. I have setup a measure called Revenue LP as&nbsp;</P><DIV><DIV><SPAN>Revenue LP = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>ReportingSalesDataFullView</SPAN><SPAN>[List Item: Amount]</SPAN><SPAN>),</SPAN><SPAN>USERELATIONSHIP</SPAN><SPAN>(</SPAN><SPAN>DimDateRelative</SPAN><SPAN>[FullDateAlternateKey]</SPAN><SPAN>,</SPAN><SPAN>DimDate</SPAN><SPAN>[FullDateAlternateKey]</SPAN><SPAN>),</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>DimDate</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>There is a filter applied to all pages on ReportingSalesDataFullView[OrderDate] for previous 1 year which sets the starting (max) range on my first date slicer (DimDate) .. but my second slicer (DimDateRelative) has a much larger date range (2011-2030 .. im not sure where this is coming from as my dataset doesnt have items in tht range) .. i would like both slicers to have the widest/max date range as that set by the all pages date filter ...</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I am new to this so may be missing a concept. and may need to provide more info on my schema.&nbsp;<img /><img /></SPAN></DIV></DIV> Tue, 11 Jul 2023 18:56:42 GMT cdelaney 2023-07-11T18:56:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-Revenue-over-Two-Date-Ranges-Using-inactive-calendar/m-p/3325928#M157486 <P>Hi,</P><P>&nbsp;</P><P>I am trying to compare revenue over two date ranges using an inactive calendar related to my active calendar. I have setup a measure called Revenue LP as&nbsp;</P><DIV><DIV><SPAN>Revenue LP = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>ReportingSalesDataFullView</SPAN><SPAN>[List Item: Amount]</SPAN><SPAN>),</SPAN><SPAN>USERELATIONSHIP</SPAN><SPAN>(</SPAN><SPAN>DimDateRelative</SPAN><SPAN>[FullDateAlternateKey]</SPAN><SPAN>,</SPAN><SPAN>DimDate</SPAN><SPAN>[FullDateAlternateKey]</SPAN><SPAN>),</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>DimDate</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>There is a filter applied to all pages on ReportingSalesDataFullView[OrderDate] for previous 1 year which sets the starting (max) range on my first date slicer (DimDate) .. but my second slicer (DimDateRelative) has a much larger date range (2011-2030 .. im not sure where this is coming from as my dataset doesnt have items in tht range) .. i would like both slicers to have the widest/max date range as that set by the all pages date filter ...</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I am new to this so may be missing a concept. and may need to provide more info on my schema.&nbsp;<img /><img /></SPAN></DIV></DIV> Tue, 11 Jul 2023 18:56:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-Revenue-over-Two-Date-Ranges-Using-inactive-calendar/m-p/3325928#M157486 cdelaney 2023-07-11T18:56:42Z