PowerPivot Table data needs altered

[Noxqss38242]

Tech Report Card Database.xlsx
	A	B	C	D
1	Date Range	Week Ending	Month1	Month
2	01/02/22 - 01/08/22	1/8/2022	Jan-22	Jan 22
3	01/09/22 - 01/15/22	1/15/2022	Jan-22	Jan 22
4	01/16/22 - 01/22/22	1/22/2022	Jan-22	Jan 22
5	01/23/22 - 01/29/22	1/29/2022	Jan-22	Jan 22
6	01/30/22 - 02/05/22	2/5/2022	Feb-22	Feb 22
7	02/06/22 - 02/12/22	2/12/2022	Feb-22	Feb 22
8	02/13/22 - 02/19/22	2/19/2022	Feb-22	Feb 22
9	02/20/22 - 02/26/22	2/26/2022	Feb-22	Feb 22
10	02/27/22 - 03/05/22	3/5/2022	Mar-22	Mar 22
11	03/06/22 - 03/12/22	3/12/2022	Mar-22	Mar 22
12	03/13/22 - 03/19/22	3/19/2022	Mar-22	Mar 22
13	03/20/22 - 03/26/22	3/26/2022	Mar-22	Mar 22
14	03/27/22 - 04/02/22	4/2/2022	Apr-22	Apr 22
Date Table

Cell Formulas
Range	Formula
D2:D14	D2	=TEXT([@Month1],"MMM YY")

I can view column C as "Jan-22", "Feb-22", "Mar-22", etc...
But when I pull it over into a power pivot, it comes across as dates. I want to view it how I can see it in the data....not dates but textual month/year as it is.

Anyone know how to accomplish this? Even a work around will do....


Thank you!

 

[GlennUK]

Formatting does not change your data to textual. The cells are still dates (check in the formula bar to see). So what does it matter that they are also dates in Power Pivot? Any such field you use as a label in a PivotTable from the Power Pivot area can also be formatted as mmm-yy