Forum Discussion
MOM not working.. Please help
Sorry, try this:
Volume LM2 = VAR varCurrentMonth = MAX( 'Fiscal Year Conversion'[YearMonth] ) VAR varPreviousMonth = CALCULATE( MAX( 'Fiscal Year Conversion'[YearMonth] ), 'Fiscal Year Conversion'[YearMonth] < varCurrentMonth ) VAR Result = CALCULATE( SUM( 'Opportunity Tracker 2.0'[Annual Volume LBS] ), 'Fiscal Year Conversion'[YearMonth] = varPreviousMonth ) RETURN ResultI am doing this without any data or model. If you need further help, please provide data, ideally a PBIX file via a share service (dropbox, onedrive, etc) that has no confidential data.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
edhans sorry, it's actually saying "The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column"
I just had an extra ] last one but fixed it and after putting exactly this:
How do I fix?
Sorry, try this:
Volume LM2 =
VAR varCurrentMonth =
MAX( 'Fiscal Year Conversion'[YearMonth] )
VAR varPreviousMonth =
CALCULATE(
MAX( 'Fiscal Year Conversion'[YearMonth] ),
'Fiscal Year Conversion'[YearMonth] < varCurrentMonth
)
VAR Result =
CALCULATE(
SUM( 'Opportunity Tracker 2.0'[Annual Volume LBS] ),
'Fiscal Year Conversion'[YearMonth] = varPreviousMonth
)
RETURN
Result
I am doing this without any data or model. If you need further help, please provide data, ideally a PBIX file via a share service (dropbox, onedrive, etc) that has no confidential data.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.