Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mansabraham
New Member

Power BI Matrix not displaying correctly

Hi,

 

I have 2 data streams. In one data stream it has data of current month + 2 months ( For today it will have revenue date wise for november 2023, December 2023, January 2024) and the second data stream has revenue for last year Nov 2022, Dec 2022 and January 2023. 

 

I want columns which shows Revenue on Books and second Column Revenue Forecast. Also the difference between Forecast and Revenue on books.

 

When I am trying to do this because of the year overlaps it is not showing correctly. Either I get figures on Nov and Dec or just January figures.

3 REPLIES 3
mansabraham
New Member

@AllisonKennedy Yes i have appended into a single table and also connected to date table using CALENDARAUTO()

 

Is there a DAX to compare NOV this year to Last year NOV, DEC this year to Last Year DEC and next year JAN to this year JAN.

@mansabraham  See if this post helps answer your question: https://excelwithallison.blogspot.com/2023/11/dax-time-intelligence-easy-pattern-to.html 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

AllisonKennedy
Super User
Super User

@mansabraham  - is 'Forecast' a value coming from your dataset or are you calculating that in Power BI?

 

Do you have a date table to connect the two data sources for this year / last year? Or even 'append' them into one table? (I'd still use a date table though too) https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.