Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi! I am wanting to create a measure calculate the change from last year same quarter.
None of the fields from my data set are technically a "data" data type. So I'm not sure how i should create the calendar table. I have a close month and close quarter and close year column in my data fields, but it says the close quarter cannot be changed to a date field which is understandable but then I don't know how i can create a relationship in my calendar to be able to do this calculation that I'm trying to do. Do i manually need to enter in dates for my calendar table? And even if i do that then how would i even link the close quarters to get my end result?
thank you for any help, let me know if I can clarify anything!
Hi @Anonymous
Would you be able to send over your PBIX file removing any sensitive data?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.