Тёмный
No video :(

Tableau YTD,PYTD | Financial Year YTD,PYTD(April-March) 

Mohit Tyagi
Подписаться 383
Просмотров 3 тыс.
50% 1

This video is about how we calculate the YTD,PYTD based on Financial Year(APRIL-MARCH)
The link is given below calculate YTD,PYTD for Jan-Dec.
• Tableau|YTD|PYTD|YoY|T...
For Tableau Training Contact Details:
Whatsapp: 8126601151
Telegram: 8279353134

Опубликовано:

 

28 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@sriram-si3hr
@sriram-si3hr Год назад
this is so helpful ,Could you perhaps help with "Quarters" I need to compare Current FY Quarters Vs Previous year Same quarters.
@Chenna_Reddy11
@Chenna_Reddy11 2 года назад
Thanks
@komaltyagi1908
@komaltyagi1908 2 года назад
Nice
@yogitashelar563
@yogitashelar563 Год назад
i am trying same formula but it return null value the version is 2022.3.1 and our data is from 2018 to january 2023 SO DATE(DATEADD('month',3, DATETRUNC('year',{MAX([Order Date])}))) this formula return value is 01/04/2023
@mohittyagi9141
@mohittyagi9141 Год назад
if you want YTD for this: if order_date>= datetrunc('year',{max(order_date)}) and order_date
@barbarahendrix6043
@barbarahendrix6043 2 года назад
Could you perhaps help with "Same periode Previous Year" in a financial year (April-March), for example i want to compare sales from 4/1/2022 till 8/9/2022 to 4/1/2021 till 8/9/2021. I want to see growth on a daily basis Thank you so much for your help!
@mohittyagi9141
@mohittyagi9141 2 года назад
iyou just need to create this syntex dateadd('year',-1,orderdate) and use this in the same calculation which you find in video
@news4955
@news4955 2 года назад
Please increase the text size to write the formula
@mohittyagi9141
@mohittyagi9141 2 года назад
sure
Далее
3 Ways to use Calculation Groups You Need to Know
20:00