Calculate YTD , QTD & PTD in a column so it can be used as an axis or legend

[Aaron1]

HI, hopeful for some help!

We would like to create a view of YTD, QTD & PTD that can be used either in the axis or legend of a visual. Our data is aggregated by week, depending on the week, it could appear in upto 3 places i.e. the latest week would be in YTD, QTD and PTD. 

We have a work around at present that relies on aggregating the data in alteryx and uploading it as a seperate (large) data table. We would like to be able to do this from the core data so it is dynamic rather than creating another huge data set.

[v-chuncz-msft]

@Aaron1,

Learn DAX basics in Power BI Desktop and show us a complete example.