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.
edhans So now that I have it sorted like this, How do I put in the fiscal month names instead of the 6 digit number of "YearMonth?"
It seems when I try to drag in month names the volume LM dissappears...
Thank you so much for your help you have no idea how much I appreciate you
As long as this is a date table, you can keep whatever you want in the visual as long as it is at the same granularity of the YearMonth field we are working off of. If there is a year and month in the visual, then the filter context will return one YYYYMM value, and that is what the measure needs.
But again, with no images, no data, no image of the model, what you are asking me to do is like calling your mechanic over the phone and saying "my car is going RRrrrrRRRrmmRRRRkkkkk. Please tell me how to fix it."
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.Sorry, So this Is what I get:
Also for some reason at the start of the fiscal year, it's not returning the previous month volume.
If I try and add Fiscal Month then I get this:
Also, any idea how to get the grand total to display at the bottom? I've tried SUmx