Forum Discussion
Sandeep_PBI
9 years agoFrequent Visitor
DAX Previous Month Function Not working
Hi, I have a simple excel sheet with 2 columns(Month, Sales) with sales related data for 4 months. And all i am trying to do is create a new colum which gives me last month's sales using a DA...
Sandeep_PBI
9 years agoFrequent Visitor
Hi,
Thanks for your response, but even though the name says month, it actually is a date fiel. i createde this sample data and made sure the format is date from the modelling options for the fiel.
All i was able to prodce was a grand total of previous month's sales. meaning, for the Previous month column i see blanks agaist each month (After grouping by month for the date field) but there is a grand total which shows up for that column and the number is correct , it is sum of all the months except the first one!
Anonymous
9 years agoNot applicable
Can you share the data model,sample data and expected output to probe further.
Cheers
CheenuSing