Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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])
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:
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.
@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...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
9 | |
8 |