Get the last value returns to blank

[Anonymous]

Hello, Looking for your best codes.
I wanted to get the previous month actual volume but it returns all blanks.
Please check my codes.

[amitchandak]

@Anonymous , do you need a measure you can do this wauth date table, like given example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum(''Table''[total hours value]),previousmonth('Date'[Date]))

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[wdx223_Daniel]

PREVIOUSMONTH return a table, not a scalar value, so it can not be compared with a date value.

[Anonymous]

@wdx223_Daniel  thanks for that, do have any solution on this codes. I wanted to show the previous month of actual volume.
Thanks for your support

[wdx223_Daniel · Accepted solution]

@Anonymous  please try this code in a calculated column

=CALCULATE(SUM(Table3[Actual Volume]),ALLEXCEPT(Table3,Table3[Segment],Table3[Sub-Segment]),PREVIOUSMONTH(Table3[Month]))

[Anonymous]

@wdx223_Daniel  thanks bro you made it. 🙂

By The way when we use allexcept that means it will not include or filter the sub-seg and segment ?

[wdx223_Daniel]

@Anonymous ALLEXCEPT means remove all filters on the table except the columns listed.