How to show Previous year 3 Months data and PY 6 Months data , PY Last Month Data

[Anonymous]

HI  PBI Experts ,

Here is my question for you in DAX ,

i want to know the sales of the Previous Year 3 Months Data Like (Jan,feb,Mar),

Previous Year 6 Months Data and Previous year Last Month Data.

Example:- Current Year = 2022

         I want Data of 2021 , 3 months Data and 6 Months data and

[tamerj1]

Hi @Anonymous 

maybe something like this might help

https://community.powerbi.com/t5/DAX-Commands-and-Tips/MTD-FOR-PREVIOUS-PERIOD/m-p/2547391#M71980