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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
esuing
Helper I
Helper I

Issue with previous month and current month data

This is frustrating me and I've spun my wheels long enough on it, so now I'm coming for help.

 

I have a simple report where the user selects the current month and I have a table that should show current month vs previous months for a value.  It works fine when the current month has a value, but if there isn't a value for the current month for a given "Ship To", then it won't display the Ship To and consequently, won't show the previous value if there is one. Here is a look at the report:

 

image.png

 

What you don't see here is the missing records where there was an FSC Dollars value in 7/1/22 for other Ship Tos, but because there was no value for 8/1/22, it's been dropped from the table. Here are my measures:

 

FSC Dollars = CALCULATE(SUM('Invoice Conditions'[Cond Dollars]),'Invoice Conditions'[Cond Type] IN {"Y826","Y806"})
FSC Prev Month Dollars = CALCULATE(SUM('Invoice Conditions'[Cond Dollars]),'Invoice Conditions'[Cond Type] IN {"Y826","Y806"},PREVIOUSMONTH('Invoice Headers'[Period Start Date]))
 
I feel like I maybe need to use an ALL or ALLEXCEPT somewhere in one of my measures, but I'm not sure. Any help would be great!
 
Thanks.
Eric
 
2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @esuing ,

 

Try to click one of your fields, and select the option "Show items with no data".  

2.png

And then your items with no data will display.

Reference: Show items with no data in Power BI - Power BI | Microsoft Learn

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thanks for the reply. Unfortunately, this did not resolve the issue.

 

Thanks.

Eric

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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