The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello
I am trying to create a table visual with current year and previous year order intake by month, that is Jan to dec.I have data from June2022 to till date , and my report has a page level filter for current year. Since there is a year filter on page , the measure previous year is showing blank . Any help I can receive on this query ?
I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.
Your insights and updates will greatly assist others who might be encountering the same challenge.
@Asf1508
I have understood the problem statement and used dummy data to solve this problem. For this, you need to assume a few things, like
1. Order intake = [sales total]
2. 2011 is your current year selected on the pane.
3. Create one [Month_name] column and sort that column with the [Month] number column.
4. There is no need to use a previous year's dax to achieve this solution.
Thanks & Regards,
Vipin Date
If this post helps, please consider accept as solution to help other members find it more quickly.