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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
IgnacioFuentes
New Member

difficulties showing only end of month dates in date slicer with time intelligence measures

Hello everyone,

 

 I have a fact table that contains only data with end-of-month dates, and that is connected to a calendar table in the data model. Additionally, I have a measure in the fact table that sums the values ​​of a field called "Valor". So far so good, I display it in a table with a date segmenter, which shows only the end-of-month date.

 

This is the measure: aux_ACTIVOS_NET_TOTALES_SIEFORES:=sum(ANSB[Valor])

 

IgnacioFuentes_0-1678995923280.png

 

 Now, I need a new measure in the same pivot table that returns the same value but from the end of the past month relative to the date selected in the date slicer, so I created the following measure:

1M_aux_ACTIVOS_NET_TOTALES_SIEFORES:=CALCULATE([aux_ACTIVOS_NET_TOTALES_SIEFORES],DATEADD(Calendario[Date],-1,MONTH))

Now the problem is that de Date Slicer is showing dates that are not end of month dates (because the use of dateadd()). I need display only end of month dates in the date slicer, is any solution available for this kind of requirements using time intelligence measures?

 

This is the resulting date slicer after using Dateadd() measure:

 

IgnacioFuentes_1-1678996551122.png

 

pd: im wonking in excel enviroment before trying on PBI. I´d really appreciate a solution that works in boths enviroments. 

 

Thank you very much in advance and greetings to all of you from Chile. 

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@IgnacioFuentes You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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