FabCon is coming to Atlanta
Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Go To
- Microsoft Fabric Community
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Power Query
- Mobile Apps
- Developer
- DAX Commands and Tips
- Custom Visuals Development Discussion
- Health and Life Sciences
- Power BI Spanish forums
- Translated Spanish Desktop
- Training and Consulting
- Instructor Led Training
- Dashboard in a Day for Women, by Women
- Galleries
- Data Stories Gallery
- Themes Gallery
- Contests Gallery
- QuickViz Gallery
- Quick Measures Gallery
- Visual Calculations Gallery
- Notebook Gallery
- Translytical Task Flow Gallery
- TMDL Gallery
- R Script Showcase
- Webinars and Video Gallery
- Ideas
- Custom Visuals Ideas (read-only)
- Issues
- Issues
- Events
- Upcoming Events
- Get Help with Data Engineering
- Data Engineering
- Galleries
- Webinars and Video Gallery
- Get Help with Data Warehouse
- Data Warehouse
- Galleries
- Webinars and Video Gallery
- Get Help with Data Science
- Data Science
- Galleries
- Webinars and Video Gallery
- Get Help
- Fabric platform
- Galleries
- Webinars and Video Gallery
- Extensibility Toolkit Gallery
- Fabric Sticker Contest Gallery
- Get Help with Data Factory
- Apache Airflow Job
- Dataflow
- Pipelines
- Mirroring
- Copy job
- Galleries
- Webinars and Video Gallery
- Get Help with Real-Time Intelligence
- Real-Time Intelligence
- Eventhouse and KQL
- Eventstream
- Activator
- Galleries
- Webinars and Video Gallery
- Get Help with Fabric IQ
- IQ
- Galleries
- Webinars and Video Gallery
- Get Help with Databases
- SQL database
- Cosmos DB (NoSQL)
- Galleries
- Webinars and Video Gallery
- Fabric community resources
- Community News
- Fabric Community Sticker Challenge Vegas 2025
- Fabric community support
- Community Accounts & Registration
- Using the Community
- Community Feedback
- Career and Learning
- Career Hub
- Hack Together
- Fabric Ideas
- Fabric Ideas
- Fabric community blogs
- Power BI Community Blog
- Data Engineering Community Blog
- Data Warehouse Community Blog
- Data Science Community Blog
- Data Factory Community Blog
- IQ Community Blog
- Real-Time Intelligence Community Blog
- Databases Community Blog
- Fabric platform Community Blog
- Power BI 中文博客
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get Fabric certified for FREE! Don't miss your chance! Learn more
- Microsoft Fabric Community
- Search
Don't see your topic?
Post your question
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
18 results
Sorted by:
08-17-2023
03:44 AM
1 Kudo
Dear Team, Sameperiodlast year is not working well when we selected the last date in the table. e.g we have data till 1st august 2023. if we select the date from slicer 31st July and 1st August...
See more ideas labeled with:
12-26-2019
10:30 AM
2 Kudos
In case of SameperiodLastYear function its taking input of metric column and date, but during the visualization if user remove the date filed. it showing error. If this function start supporting at a...
See more ideas labeled with:
11-05-2018
02:02 PM
8 Kudos
Hello Power BI team, On top of existing Quick Measure Time Intelligence functions, a most commonly used comparison is vsç last year results. To make it easier for all users can you please add SAMEPERIODLASTYEAR...
See more ideas labeled with:
08-09-2021
06:26 AM
2 Kudos
Currently SAMEPERIODLASTYEAR automatically goes to the end of the month, so in reality it is not measuring the same period. Below is a fix that I am having to implement. Thankfully I QA'd my w...
See more ideas labeled with:
10-03-2017
08:53 PM
2 Kudos
When I calculate difference vs same period previous year - I drag difference amount in table or matrix first year data is unreadable when using filter. Please add possibility to exclude this column o...
See more ideas labeled with:
02-28-2017
06:06 PM
695 Kudos
I'd like to be able to create reusable functions in DAX, instead of using the same DAX code in multiple measures. Example: I have some complicated DAX code, which calculates the no of working second...
See more ideas labeled with:
03-20-2025
08:39 AM
Bug when comparing YOY Results February is not Accounting for leap year when using SAMEPERIODLASTYEAR Formula
See more ideas labeled with:
03-19-2019
06:59 PM
3,132 Kudos
Support the creation of DAX calculation groups in Power BI Desktop - otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this ...
See more ideas labeled with:
05-31-2023
07:19 PM
1 Kudo
I think it a good ideia let de name of the functions in Capital letter only the begin of the words. Example SAMEPERIODLASTYEAR by SamePeriodLastYear. It's much better to read on this way....
See more ideas labeled with:
10-07-2024
10:00 PM
4,644 Kudos
Imagine a world where report creators can automatically apply slicer and filter selections based on specific logic, revolutionizing data analysis and user experience. This innovative approach elimina...
See more ideas labeled with: