コンテンツへスキップ

if(less(variables('ThisMonth'),4),'3Q',if(less(variables('ThisMonth'),7),'1Q',if(less(variables('ThisMonth'),10),'2Q','3Q')))

現在時刻取得

convertTimeZone(utcNow(),'GMT Standard Time','Tokyo Standard Time','u')
月Monthを取得 variables('ThisMonth')
variables('ThisMonth'):
   int(formatDateTime(convertTimeZone(utcNow(),'GMT Standard Time','Tokyo Standard Time','u'),'MM'))

日付フォーマット

タイムゾーン名、タイムゾーンID

  • GMT Standard Time
  • Tokyo Standard Time

Summary


The table below lists out the Microsoft Time Zone Index Values.

More Information


Index (hex)Name of Time ZoneTime
0Dateline Standard Time(GMT-12:00) International Date Line West
1Samoa Standard Time(GMT-11:00) Midway Island, Samoa
2Hawaiian Standard Time(GMT-10:00) Hawaii
3Alaskan Standard Time(GMT-09:00) Alaska
4Pacific Standard Time(GMT-08:00) Pacific Time (US and Canada); Tijuana
AMountain Standard Time(GMT-07:00) Mountain Time (US and Canada)
DMexico Standard Time 2(GMT-07:00) Chihuahua, La Paz, Mazatlan
FU.S. Mountain Standard Time(GMT-07:00) Arizona
14Central Standard Time(GMT-06:00) Central Time (US and Canada)
19Canada Central Standard Time(GMT-06:00) Saskatchewan
1EMexico Standard Time(GMT-06:00) Guadalajara, Mexico City, Monterrey
21Central America Standard Time(GMT-06:00) Central America
23Eastern Standard Time(GMT-05:00) Eastern Time (US and Canada)
28U.S. Eastern Standard Time(GMT-05:00) Indiana (East)
2DS.A. Pacific Standard Time(GMT-05:00) Bogota, Lima, Quito
32Atlantic Standard Time(GMT-04:00) Atlantic Time (Canada)
37S.A. Western Standard Time(GMT-04:00) Georgetown, La Paz, San Juan
38Pacific S.A. Standard Time(GMT-04:00) Santiago
3CNewfoundland and Labrador Standard Time(GMT-03:30) Newfoundland
41E. South America Standard Time(GMT-03:00) Brasilia
46S.A. Eastern Standard Time(GMT-03:00) Georgetown
49Greenland Standard Time(GMT-03:00) Greenland
4BMid-Atlantic Standard Time(GMT-02:00) Mid-Atlantic
50Azores Standard Time(GMT-01:00) Azores
53Cape Verde Standard Time(GMT-01:00) Cape Verde Islands
55GMT Standard Time(GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London
5AGreenwich Standard Time(GMT) Monrovia, Reykjavik
5FCentral Europe Standard Time(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
64Central European Standard Time(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
69Romance Standard Time(GMT+01:00) Brussels, Copenhagen, Madrid, Paris
6EW. Europe Standard Time(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
71W. Central Africa Standard Time(GMT+01:00) West Central Africa
73E. Europe Standard Time(GMT+02:00) Minsk
78Egypt Standard Time(GMT+02:00) Cairo
7DFLE Standard Time(GMT+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius
82GTB Standard Time(GMT+02:00) Athens, Bucharest, Istanbul
87Israel Standard Time(GMT+02:00) Jerusalem
8CSouth Africa Standard Time(GMT+02:00) Harare, Pretoria
91Russian Standard Time(GMT+03:00) Moscow, St. Petersburg, Volgograd
96Arab Standard Time(GMT+03:00) Kuwait, Riyadh
9BE. Africa Standard Time(GMT+03:00) Nairobi
9EArabic Standard Time(GMT+03:00) Baghdad
A0Iran Standard Time(GMT+03:30) Tehran
A5Arabian Standard Time(GMT+04:00) Abu Dhabi, Muscat
AACaucasus Standard Time(GMT+04:00) Baku, Tbilisi, Yerevan
AFTransitional Islamic State of Afghanistan Standard Time(GMT+04:30) Kabul
B4Ekaterinburg Standard Time(GMT+05:00) Ekaterinburg
B9West Asia Standard Time(GMT+05:00) Tashkent
BEIndia Standard Time(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
C1Nepal Standard Time(GMT+05:45) Kathmandu
C3Central Asia Standard Time(GMT+06:00) Astana, Dhaka
C8Sri Lanka Standard Time(GMT+06:00) Sri Jayawardenepura
C9N. Central Asia Standard Time(GMT+06:00) Almaty, Novosibirsk
CBMyanmar Standard Time(GMT+06:30) Yangon (Rangoon)
CDS.E. Asia Standard Time(GMT+07:00) Bangkok, Hanoi, Jakarta
CFNorth Asia Standard Time(GMT+07:00) Krasnoyarsk
D2China Standard Time(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi
D7Singapore Standard Time(GMT+08:00) Kuala Lumpur, Singapore
DCTaipei Standard Time(GMT+08:00) Taipei
E1W. Australia Standard Time(GMT+08:00) Perth
E3North Asia East Standard Time(GMT+08:00) Irkutsk, Ulaanbaatar
E6Korea Standard Time(GMT+09:00) Seoul
EBTokyo Standard Time(GMT+09:00) Osaka, Sapporo, Tokyo
F0Yakutsk Standard Time(GMT+09:00) Yakutsk
F5A.U.S. Central Standard Time(GMT+09:30) Darwin
FACen. Australia Standard Time(GMT+09:30) Adelaide
FFA.U.S. Eastern Standard Time(GMT+10:00) Canberra, Melbourne, Sydney
104E. Australia Standard Time(GMT+10:00) Brisbane
109Tasmania Standard Time(GMT+10:00) Hobart
10EVladivostok Standard Time(GMT+10:00) Vladivostok
113West Pacific Standard Time(GMT+10:00) Guam, Port Moresby
118Central Pacific Standard Time(GMT+11:00) Magadan, Solomon Islands, New Caledonia
11DFiji Islands Standard Time(GMT+12:00) Fiji, Kamchatka, Marshall Is.
122New Zealand Standard Time(GMT+12:00) Auckland, Wellington
12CTonga Standard Time(GMT+13:00) Nuku'alofa
80000040Azerbaijan Standard Time(GMT-03:00) Buenos Aires
80000041Middle East Standard Time(GMT+02:00) Beirut
80000042Jordan Standard Time(GMT+02:00) Amman
80000043Central Standard Time (Mexico)(GMT-06:00) Guadalajara, Mexico City, Monterrey - New
80000044Mountain Standard Time (Mexico)(GMT-07:00) Chihuahua, La Paz, Mazatlan - New
80000045Pacific Standard Time (Mexico)(GMT-08:00) Tijuana, Baja California
80000046Namibia Standard Time(GMT+02:00) Windhoek
80000047Georgian Standard Time(GMT+03:00) Tbilisi
80000048Central Brazilian Standard Time(GMT-04:00) Manaus
80000049Montevideo Standard Time(GMT-03:00) Montevideo
8000004AArmenian Standard Time(GMT+04:00) Yerevan
8000004BVenezuela Standard Time(GMT-04:30) Caracas
8000004CArgentina Standard Time(GMT-03:00) Buenos Aires
8000004DMorocco Standard Time(GMT) Casablanca
8000004EPakistan Standard Time(GMT+05:00) Islamabad, Karachi
8000004FMauritius Standard Time(GMT+04:00) Port Louis
80000050UTC(GMT) Coordinated Universal Time
80000051Paraguay Standard Time(GMT-04:00) Asuncion
80000052Kamchatka Standard Time(GMT+12:00) Petropavlovsk-Kamchatsky

PowerBIやPower Queryでのカレンダー作成用のクエリー

カレンダー
=ADDCOLUMNS (CALENDAR ("2015/1/1", "2035/12/31"),
"年", YEAR([Date]),
"月", FORMAT ( [Date], "m月" ),
"年月", FORMAT ( [Date], "yyyy年mm月" ),
"月番号", MONTH([Date]),
"曜日番号", WEEKDAY ( [Date], 1),
"週番号", WEEKNUM([Date],1),
"曜日", SWITCH(WEEKDAY([Date],1), 1, "月", 2, "火", 3, "水", 4, "木", 5, "金", 6, "土", 7, "日",""),
"会計年度", IF(MONTH([Date])<4,YEAR([Date])-1,YEAR([Date])),
"四半期", IF(MONTH([Date])<4,"Q4",IF(MONTH([Date])<7,"Q1",IF(MONTH([Date])<10,"Q2","Q3"))),
"半期", IF(MONTH([Date])<4,"下期",IF(MONTH([Date])<10,"上期","下期")),
"半期番号", IF(MONTH([Date])<4,2,IF(MONTH([Date])<10,1,2)),
"日番号", DAY([Date]),"日", FORMAT([Date],"d日"),"YearMonth", FORMAT([Date],"yymm"))