Hi, I'm new to Power BI.
My company Fiscal year is from 01st JUly to 30 June.
I have the Sales Data (Sales CY)which includes Date wise.Another file Day wise Budgeted Sales (Budget Sales),another file Day wise Lat Year Sales (Sales LY). I have created the Date Master file and connected to Budgeted Sales & Sales CY.
I want to prepare the Sales CY Vs Budget Sales and Sales LY as per the selection of Dates (comes from Calendar Master). I have used the Measure
LY=calculate(Sales CY[Sales],dateadd(Datemaster[date],-365,day). But There is not output. Please can any expert share some solutions?
Also, if anybody have some link where explains about the Fiscal Calendar is different from the Calendar it would be much helpful.
Suresh.
My company Fiscal year is from 01st JUly to 30 June.
I have the Sales Data (Sales CY)which includes Date wise.Another file Day wise Budgeted Sales (Budget Sales),another file Day wise Lat Year Sales (Sales LY). I have created the Date Master file and connected to Budgeted Sales & Sales CY.
I want to prepare the Sales CY Vs Budget Sales and Sales LY as per the selection of Dates (comes from Calendar Master). I have used the Measure
LY=calculate(Sales CY[Sales],dateadd(Datemaster[date],-365,day). But There is not output. Please can any expert share some solutions?
Also, if anybody have some link where explains about the Fiscal Calendar is different from the Calendar it would be much helpful.
Suresh.