Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

LTM in Power BI

Dear expert   I have a question regarding LTM formula and hope anyone could help.   I would like to create a "LTM sales" and "LTM Qty" columns which can show "AllData.Sales" and "AllData.Qty" du...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank for your quick response.

 

I try the formula and it gave me the total sales qty cover that month in each column. ( as the tick below)

 

However, i need it to show the same qty as "AllData.Qty" as my prior email attachment. In this case when i do the table ( as the black table attached) will show the same as CY.

 

Sorry, i am new with Power BI and not sure what to fill up instead of "sum" in your formula. -  CALCULATE(sum(Sales[Sales Amount])

Please advise.

 

Thank you in advance.

 

Maggie

 

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , You are creating a column, and that will sum up all values. I am suggesting a measure. Try a measure and check.

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.