topic Re: Creating a table visual with cuurent year and previous year order intake in DAX Commands and Tips

Creating a table visual with cuurent year and previous year order intake

Asf1508 — Mon, 28 Aug 2023 20:41:54 GMT

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 ?

Re: Creating a table visual with cuurent year and previous year order intake

Anonymous — Tue, 29 Aug 2023 06:08:28 GMT

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.

Re: Creating a table visual with cuurent year and previous year order intake

technolog — Sun, 24 Sep 2023 14:44:53 GMT

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.