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 everyone,
I am looking for help regarding Power BI Time Intelligence Function on LYTD.
I had YTD, LYTD sales figures. But, the Current LYTD function was providing all the sales for last year. (I am looking for something that LYTD needs to give the data up to the same period the previous year)
Sales LYTD = CALCULATE([SalesAUD],DATEADD('Master Calendar'[Date],-1,YEAR))
And
Sales AUD is the total sales.
I want to stop the FY22 LYTD sales data, which are across the current month.
Thanks.
Sales LYTD = if([SalesAUD],CALCULATE([SalesAUD],DATEADD('Master Calendar'[Date],-1,YEAR)))
Hey, Thanks for sharing the knowledge.
It seems like working, what I am looking for. But, Why the total was getting total sales amount for last year instead of summing only those months sales.
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 |
---|---|
44 | |
21 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |