https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-calculating-Months-on-Book/m-p/1449019#M27197 <P>Anonymous</LI-USER> , Try a measure like</P> <P>if(max(Date[Date]) &lt;=CALCULATE(max(Sales[Sales date]),DATESYTD('Date'[Date])), CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date])),blank())</P> Thu, 22 Oct 2020 09:28:27 GMT amitchandak 2020-10-22T09:28:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-calculating-Months-on-Book/m-p/1448539#M27184 <P>Hi</P><P>&nbsp;</P><P>Please can you assist. I'm trying to calculate Months on book to replicate this graph.</P><P><img /></P><P>Currently I've calculated it this way :&nbsp;</P><DIV><DIV><SPAN>MOB = ([MaxYear]-'ROLL RATES'[Year])*12 + ([MaxMonth]- 'ROLL RATES'[Month]) but its reversed my values.All the highlighted data points should start at MOB1.</SPAN></DIV><DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV></DIV> Thu, 22 Oct 2020 06:44:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-calculating-Months-on-Book/m-p/1448539#M27184 Anonymous 2020-10-22T06:44:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-calculating-Months-on-Book/m-p/1449019#M27197 <P>Anonymous</LI-USER> , Try a measure like</P> <P>if(max(Date[Date]) &lt;=CALCULATE(max(Sales[Sales date]),DATESYTD('Date'[Date])), CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date])),blank())</P> Thu, 22 Oct 2020 09:28:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-calculating-Months-on-Book/m-p/1449019#M27197 amitchandak 2020-10-22T09:28:27Z