R12 Month Questions

Question

I am newer to PBI and having problems with R12 month DAX code.&nbsp;&nbsp;I am trying to find the rolling 12 month of concrete qty and want to see what they are monthly. I am using DAX code--&nbsp;&nbsp;Last 12 Months =CALCULATE ( [Concrete Qty],&nbsp; &nbsp; &nbsp; DATESINPERIOD ( 'Ticket'[Ticketed Date], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- returns period from date column&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX ( 'Ticket'[Ticketed Date] ), &nbsp;-- starting from MAX date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -12, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- shifting it back 12 intervals&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MONTH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- each interval being a month&nbsp; &nbsp; &nbsp; ))&nbsp;When I put these in a matrix with total Concrete QTY I am getting the same values.&nbsp;&nbsp;Can anyone tell me what I am doing wrong?&nbsp;&nbsp;

dangar332 · Answer

HI,&nbsp;Anonymous&nbsp;&nbsp;just adjust your table and&nbsp; column nameuse below code instead of&nbsp;&nbsp;MAX&nbsp;(&nbsp;'Ticket'[Ticketed Date]&nbsp;)calculate(&nbsp;MAX&nbsp;(&nbsp;'Ticket'[Ticketed Date]&nbsp;),allexcept('yourtablename','ticket'[yearcolumnname]))

Forum Discussion

R12 Month Questions

1 Reply

Related content

R12 on montly page

Bookmark questions

Architecture question and brainstorming

Unpivot Question

Field Parameter Question