• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DAX Formula to Refer to Previous Column Values

Willstein818

New Member
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:
72732

72733

Thanks a lot.

Regards,
William
 

Attachments

  • Sample.xlsx
    713.1 KB · Views: 0
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.
 
Back
Top