DAX Formula to Refer to Previous Column Values

[Willstein818]

Hi Everyone,

So I have a set of data that I want to calculate the value differences between this month and previous months. Normally, I could use Shown as Value features to do this. However, the downside of using this feature is that the values produced could not be used for later calculations. Is there any DAX Measures formula to create the same result? Because I could not seem to use LOOKUPVALUE or PREVIOUSMONTH in this data. Or could there be a way to make Show as Value as a permanent value? My sample data are attached below .

My Data:




Thanks a lot.

Regards,
William

 

[GraH - Guido]

Hi,
Date and time intelligence functions in DAX only work with proper dates. Month names are not dates. PreviousMonth won't work in that case.
Best is to have a proper date column in your data and have it linked to a calendar table.
That way PreviousMonth works and from your calendar table the month name can be taken to create the pivot.