Create Calendar Table & Calculate Total Sales by Fiscal Period in Power Pivot Data Model

  Рет қаралды 922

Abiola David

Abiola David

Күн бұрын

Пікірлер: 6
@IvanCortinas_ES
@IvanCortinas_ES Жыл бұрын
Excellent video David. The topic of the fiscal year in companies is very interesting. Congratulations on the MVP award, absolutely deserved, my friend. Thank you so much!!!
@Abioladavid01
@Abioladavid01 Жыл бұрын
Thanks for your comment friend
@abdallahdataguy
@abdallahdataguy Жыл бұрын
Great video Abiola. I like using FYYearQuarter like "FY2012Q4" or just 2012Q4 which automatically sorts in pivot table
@anisa5656-l1z
@anisa5656-l1z 5 ай бұрын
If it is assumed fiscal year starts from July and I used the function as . But calendar quarter '1', the result comes '-1' and calendar 'quarter 2' is showing '0'. Could you tell me, where is my error in the function?
@MahmoudAnass-c9n
@MahmoudAnass-c9n Жыл бұрын
How about if the Fiscal year starts from July till June? what should be right formula? for both FY Quarter and FY
@Abioladavid01
@Abioladavid01 Жыл бұрын
Then you have to replace the 4 with 6 in the Fiscal Quarter calculated column
Create an Interactive Checklist in Excel
8:28
Computergaga
Рет қаралды 834 М.
ЛУЧШИЙ ФОКУС + секрет! #shorts
00:12
Роман Magic
Рет қаралды 21 МЛН
How Strong is Tin Foil? 💪
00:25
Brianna
Рет қаралды 58 МЛН
What is a Date Table / Calendar table in Power BI / Excel
20:06
Access Analytic
Рет қаралды 38 М.
How to use Power Pivot in Excel | Full Tutorial
30:38
Kevin Stratvert
Рет қаралды 1,4 МЛН
Master Power BI: Create Your Own Easy Fiscal Year Calendar
9:39
Miss Microsoft
Рет қаралды 17 М.
Create a Many to Many Relationship Model in Power Pivot
10:58
Fiscal Year Date Table in Power BI
17:54
Goodly
Рет қаралды 72 М.
3 Easy Ways to Create Your Power BI Calendar Table 🗓️ / Date Table
22:55
Avi Singh - PowerBIPro
Рет қаралды 106 М.