START() fn is used to return first date in time period. Which function is used to return first month of time period?
Make the line-item to 'Month' format. Then say PERIOD(START())
@saurav4ss
If you want to find first Period of the timescale => OFFSET(1,-1,0) = 0
If you want to get the first month of every year, there are multiple ways to do so. You can convert the above boolean into number and then add 12 into it and then find MOD of that number. Result of 1 is the First month of every year.
Hello - I've had perfectly working powerbi extract from Anaplan until this Monday. We havent introduced any changes in the model. The query fails in the navigation step right after source. I get the error "The column: Column1 not found in the table". Experimenting with a clean file i get the same error before i do any…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
