Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm strugeling wirth a issue in my powerbi inventory reporting.
My inventory number ("Flux" here) is a sum from the begining of my table.
With the Date ("DateDone" here) in a filter/slider, i can see the data of my inventory for a product at a specific period, but i would like to see also the inventory of this product at the same date for the last year.
With the dax formula "SAMEPERIODLASTYEAR"
the issue is that the date and the Flux sum returned is always the last date of the previous year
So for the 01/09/2021, the last year Flux ("LY Flux") will be the sum of the 31/12/2020, not the 01/09/2020
Can you help me with that please ?
Best regards
Solved! Go to Solution.
Hi @Loan ,
SAMEPERIODLASTYEAR is a time intelligence function,you'd better first create a calendar table then create a relationship between the date table and the fact table.
Finally using below expression instead.
LY FLUX = CALCULATE(SUM('odoo StockMove'[Flux]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Check below examples:
https://databear.com/power-bi-dax-sameperiodlastyear-paralellperiod-and-dateadd/
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @Loan ,
SAMEPERIODLASTYEAR is a time intelligence function,you'd better first create a calendar table then create a relationship between the date table and the fact table.
Finally using below expression instead.
LY FLUX = CALCULATE(SUM('odoo StockMove'[Flux]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Check below examples:
https://databear.com/power-bi-dax-sameperiodlastyear-paralellperiod-and-dateadd/
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
@Loan 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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |