Hi,
I'm given a spreadsheet with no actual dates but only FY and Quarters in two separate columns. How do I convert the Quarter column to reflect it is a date so I may use it in Power BI?
Many thanks in advance.
Here is a sample:
*The actual file is much larger with many more rows and jumps around between the quarters.
| Store | Type | Product Line | FY | Qtr | Amount | | A | Forecasted Sales | Dairy | 2024 | Q1 | 4,500 | | A | Forecasted Sales | Bakery | 2024 | Q1 | 3,000 | | A | Forecasted Sales | Beverage | 2024 | Q1 | 4,500 | | B | Forecasted Sales | Dairy | 2024 | Q1 | 3,000 | | B | Forecasted Sales | Bakery | 2024 | Q1 | 5,700 | | B | Forecasted Sales | Beverage | 2024 | Q1 | 4,500 | | C | Forecasted Sales | Dairy | 2024 | Q1 | 4,500 | | C | Forecasted Sales | Bakery | 2024 | Q1 | 4,500 | | C | Forecasted Sales | Beverage | 2024 | Q1 | 5,500 | | A | Forecasted Sales | Dairy | 2024 | Q2 | 3,750 | | A | Forecasted Sales | Bakery | 2024 | Q2 | 4,200 | | A | Forecasted Sales | Beverage | 2024 | Q2 | 4,500 | | B | Forecasted Sales | Dairy | 2024 | Q2 | 3,750 | | B | Forecasted Sales | Bakery | 2024 | Q2 | 5,400 | | B | Forecasted Sales | Beverage | 2024 | Q2 | 4,800 | | C | Forecasted Sales | Dairy | 2024 | Q2 | 4,500 | | C | Forecasted Sales | Bakery | 2024 | Q2 | 4,500 | | C | Forecasted Sales | Beverage | 2024 | Q2 | 5,500 | | A | Forecasted Sales | Dairy | 2024 | Q3 | 3,500 | | A | Forecasted Sales | Bakery | 2024 | Q3 | 4,200 | | A | Forecasted Sales | Beverage | 2024 | Q3 | 5,400 | | B | Forecasted Sales | Dairy | 2024 | Q3 | 3,900 | | B | Forecasted Sales | Bakery | 2024 | Q3 | 5,500 | | B | Forecasted Sales | Beverage | 2024 | Q3 | 6,000 | | C | Forecasted Sales | Dairy | 2024 | Q3 | 4,500 | | C | Forecasted Sales | Bakery | 2024 | Q3 | 4,800 | | C | Forecasted Sales | Beverage | 2024 | Q3 | 5,750 |
|
