More than 3 years have passed since last update.

Power BI Calendarテーブルに会計年度を追加する

PowerBI
DAX
PowerBIDesktop

Last updated at 2020-12-16Posted at 2020-12-16

DAX関数

4月始まり、3月決算の場合

calendar = 
ADDCOLUMNS (
CALENDAR (DATE(2018,4,1), DATE(2021,3,31)),
"会計年度", IF((MONTH([Date])>=4 && MONTH([Date])<=12),Year([Date]),Year ([Date])-1)
)

参考

Power BIで日付テーブルを作る - Qiita
Power BI（DAX）のカスタムカレンダー - 会計四半期の計算列 - powerbi、dax

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up