Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi!! Please, can anyone help me withs this?
I need to build a formula that let me sum current period and too brings me the sum of the same period of the last year.
I have a problem with the SamePariodLastYear, DATEADD, and others Function. It works fine, but when I filter a disticnt months I get the error. Because the function only accepts contiguous dates In Slicer. The problem for what I researched is this, these functions only accept continuous periods, for example January, February, March etc. If I filter for example January, April, September then it gives an error.
If i filter "January" and "September" i need the formula brings me the sum of the same period of the last year, thats what i need.
@rlsantos 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 |
---|---|
15 | |
10 | |
10 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |