cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Flyism
New Member

No email data from 2020 in 2021

Hey everyone, 

 

i developed a dashboard that shows how well your emails are performing (different measures etc.) and it worked perfectly in 2020. I work with two tables. The first one is filled with email data (name, total sendings etc.) and the other one is just data describing these emails (type, topic....) 

 

My problem is that i cant find any data from mails created in 2020 in 2021. Some mails were sent multiple times, therefore i should have data in 2021 even though the first sending was in 2020. It only shows the new mailings created after 1.1.21

 

I appreciate any advice. Thanks 🙂

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Flyism 
Seems like a filter or slicer problem caused by inappropriate relationship.

A few question, how is the date table used and how do the 2 tables related? It would be best if you can provide a sample.

 

Regards
Paul

 

 

amitchandak
Super User
Super User

@Flyism , difficult to tell without some example data .

Check your tables what are the dates is showing.

If you using a date table; make sure it has all dates.

 

Check if some join is failing, because on of the date has timestamp

 

Any other filter like year at visual, page or report level.



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines
pranit828
Community Champion
Community Champion

Hi @Flyism 

Do you have a date filter in your dataset? 

Check that, hopefully it has 1/1 and current year hardcoded.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.