exceldategoogle-sheetsexcel-formulalooker-studio
How can I combine Month Column and Year Column in Excel into Month-Year so that Google Data Studio / Looker Studio can detect it as Date?
I Have data that look like this:
Column A : Year 2020 2020 2020 2021 2021 2021 etc
Column B : Month 1 2 3 4 5 6 etc
How can I combine Month Column and Year Column in Excel into Month-Year so that Google Data Studio / Looker Studio can detect it as Date???
Because when I use this format in Google Data Studio, "Year" column doesn't support date format, while Month column can be detected in GDS. What is the proper date format for Google Data Studio?? Do I have to change the date format in Google Data Studio or change it in Excel??
Solution
You may create n' use a calculated field within the dash to create a date field based on two existing dimensions of Year & Month_Number
PARSE_DATE("%F",CONCAT(Year,"-",Month,"-",1))
- How to border cells based on where the user click?
- Difference between running a userform in Visual Basic Editor (F5) and opening it with Show?
- VBA delete row working in one for loop but not another
- How to get HEX color value from cell color?
- Remove columns if the number of rows is less than a certain number using vba Excel
- VBA Security : my vbe password is well-set, but still can be hacked by a simple code
- Adjust vertical scrollbar range in Excel userform listbox
- Delete user ribbon from file
- Excel Hide/Show all tabs on Ribbon except custom tab
- Partial value font color in red using vba
- How do I conditionally append a row of Excel data from one sheet to another?
- Efficient formula or code to determine number of errors in range VBA
- Rank numbers including NA()s in Excel 365
- Is it possible to have a named range attached to "activesheet," rather than a specific sheet?
- How to calculate YoY Growth without a Date Field in Pivot?
- Excel hyperlinks 'Can't open specified file' on Mac
- Is it possible to dynamically change a cell/column reference in an excell formula based on another cell
- Excel - create a list from a data column but ignore/remove blank cells
- Split text string in Excel by semicolons and space
- Formula in Excel to count occurrences of substrings within strings
- find closed match value in matrix and return its row and column header in excel
- VBA to allow users to format cells on locked worksheet
- How can my For Each Loop loop to the next row?
- Excel - Return value based in two conditions
- Power Query, M language, Count items in a row with Special condition
- excel group column highlight matching values
- VBA - Save email object (OLEFormat) to file from clipboard
- excel vba projects not closing
- Excel VBA variable Chart Range
- Changing the Date Format for GROUPED dates in a PIVOT TABLE