https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Calculate-Backlog/m-p/1887504#M3726 <P>Hi ...I have 3 fields [Receipt Date], [Invoice Date] and [Sales]&nbsp; ... how do i calcualte what jobs were still open at the end of the previous months.&nbsp; Basicall im looking for historical sales backlog.&nbsp; Im very new to PBI and dont have much DAX experience.&nbsp; any help would be appreciated.</P><P>&nbsp;</P><P>wanda</P> Tue, 08 Jun 2021 09:45:06 GMT wanda 2021-06-08T09:45:06Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Calculate-Backlog/m-p/1887504#M3726 <P>Hi ...I have 3 fields [Receipt Date], [Invoice Date] and [Sales]&nbsp; ... how do i calcualte what jobs were still open at the end of the previous months.&nbsp; Basicall im looking for historical sales backlog.&nbsp; Im very new to PBI and dont have much DAX experience.&nbsp; any help would be appreciated.</P><P>&nbsp;</P><P>wanda</P> Tue, 08 Jun 2021 09:45:06 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Calculate-Backlog/m-p/1887504#M3726 wanda 2021-06-08T09:45:06Z