DAX or Power Query for dates?

[Powerbipatronus]

I'm new to Power BI and DAX, so any help would be greatly appreciated.

I'm working on a report where I need to see the months (MMMYY) where a new purchase was made. I've made variables for first and last purchase order. I've tried DATESDIFF, calculated columns, and measures. I know it's more complicated than my brain is ready for, but I'd really like to be able to solve this problem. Thanks!

[johnt75]

You need to set up a proper date table and mark it as a date table, there are lots of articles and videos about it. Once you've done that and linked the date table to your fact table then you can use columns from your date table in your visuals and your measures will automatically show the numbers for the appropriate period.

[Pragati11]

Hi @Powerbipatronus ,

I think you will need to add more details here like what calculations did you create? What is working and what is not? Some sample data, etc.