Forum Discussion
Need Assistance on M Code
Hi, Is it possible to create M or SQL Code wherein if any of the StartDate, EndDate or Reporting Month were changed then a refreshed was done the data would only covered what was specified. Eg. R...
Hi Anonymous ,
Have a read through this to see how you can help us to help you get to the answer you're looking for quickly and correctly:
Pete
Click here to download example PBIX solution fro Onedrive
Click here
Test it by changing data in Input and then look at output
Use
Date.AddDays([#" Date in"], -31)
and then use a condition to only apply it to "Reporting mth"
This works exactly as requested so please click [accept solution] and the thumbs up.
We are unpaid volunteers so please be generous and click to reward kudos for our time and effort.
Thank you.
If you asked the wrong question then please still click [accept solution] and the thumbs up.
Then raise a new ticket, because it is unfair to not to reward kudos if you have asked vague or careless questions.