cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
o59393
Post Prodigy
Post Prodigy

How to show the first of each month in date format

Hi all

 

I have a calendar date table that contains the dates between 1/1/2017 and 12/1/2020

 

On another table I have data that contains values for the first of each month only.

 

When I create a table I am getting the values for every single day, and when I switch it to date hierarchy i get just the month and year. 

 

I would like to keep the date format with the data just for the first of each month. Something like this:

 

date1.PNG

 

Currently I get this:

date2.PNG

 

Hierarchy mode:

 

date3.PNG

 

How can I get it right?

 

Thanks!

1 ACCEPTED SOLUTION

@o59393 I only download file from google drive or one drive, or send me directly to my email which is in the signature.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

4 REPLIES 4
o59393
Post Prodigy
Post Prodigy

The solution @parry2k  it's perfect.

 

Use a new column

Start of Month = EOMONTH( 'date'[date], -1) +1
 
Thanks.
parry2k
Super User III
Super User III

@o59393 it depends how your tables are connected and what is in measure. Seems like you are seeing each date because one of it is not correct. Can you share relationship diagram and measure expressions?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hi @parry2k 

 

Please look at the table safety validation as an example.

 

Thanks.

@o59393 I only download file from google drive or one drive, or send me directly to my email which is in the signature.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors