Tableau| Fiscal Year vs Calendar Year

Hello Everyone,
In this video we are going to #solve #complex #tableauscenarios that is very important in #realtime. Converting Normal Calender to Fiscal Calender and #parameter usecase.
Regards,
Rahul.
#wellsfargointerview
#kpmg,
#viralinterview ,
#capgeminiinterview ,
#tableauinterview,
#Tableaudeveloper,
#interviewquestions,
#tableauscenarios,
#sqlinterview,
#tcsinterview,
#creatingforindia
#TableauInterview
#DataVisualization
#TableauTips
#InterviewPreparation
#DataAnalytics
#DataViz
#JobInterview
#DataScience
#TableauSolutions
#CareerAdvice
#TableauExperts
#DataInterview
#TableauSkills
#TechInterview
#InterviewSuccess
Please like share and subscribe.
#xpressurdata
#tableau
#tableaututorial
#tableaudeveloper
tableau interview
tableau training
tableau desktop specialist exam
tableau interview questions & answers
tableau interview experience
tableau interview questions
tableau developer interview questions
tableau interview questions in telugu
tableau interview questions in hind
tableau desktop specialist
tableau certification
tableau desktop specialist exam questions
lod in tableau
tableau server tutorial
tableau server
tableau lod
sql interview questions and answers
xpressdata
parameters in tableau
filters in tableau
tableau projects

[@sumitchaudhari5815]

even if we converted column to fiscal year the calculations for ytd, mtd, qtd, and other are not working as calender year e.g. for ytd year(date)=year(today) takes only from jan 2024 till date same for other.so i tried this it worked for ytd fiscal year april to march till date means todays date
SUM(IF MONTH([cur_date])>=4 AND YEAR([cur_date])=YEAR(TODAY())-1
OR
YEAR([cur_date])=YEAR(TODAY())
AND
[cur_date]

[@TechiRahul]

Might need to tweak a Lil to fill all conditions

[@tapanshah8061]

Hi, I am just curious for the calculation you created for fiscal year.
How is it considering January of next year ? your conditon says month(order date)>=4... where as the month of january is 1... it is not grater than 4. still how the next year january is populating