Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Vern2022
Contributor III
Contributor III

Creating Master Dimension to Only Return Months in a Particular Year

Hi,

I have a large data set which dates back to 2008 from now but I only want the graph to display months for this financial year. So I thought to create a dimension in Masters using the syntax below but all columns are being returned. Can you please advise me what I am doing wrong. Many thanks.


This is my code:

=if([Financial Year] >= '2022/23',[Financial Year Month])

 

Many thanks.

Labels (7)
1 Reply
BrunPierre
Partner - Master
Partner - Master

Let's see your master calendar script.