Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

R12 Month Questions

I am newer to PBI and having problems with R12 month DAX code.    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--    Last 12...
Need Help
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

HI, Anonymous 

 

just adjust your table and  column name

use below code instead of  MAX ( 'Ticket'[Ticketed Date] )


calculate( MAX ( 'Ticket'[Ticketed Date] ),allexcept('yourtablename','ticket'[yearcolumnname]))