Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi @abyars ,
Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have also figured out that the grand total is correct, but after the first subtotal, the subtotals are all incorrect.
Hi @abyars ,
Here are some suggestions:
- Make sure you have a proper date table that is marked as date in the model view and has a one-to-many relationship with your fact table. You can use the CALENDAR() or CALENDARAUTO() functions to create a date table.
- Try using the DATEADD() function instead of SAMEPERIODLASTYEAR() to shift the dates by one year.
- Check if your date column has any gaps or missing values that might affect the calculation of SAMEPERIODLASTYEAR(). You can use the ISBLANK() function to identify any blank values and replace them with appropriate values.
- If you are using a slicer or filter to select a specific time period, make sure it is applied to both the current year and the previous year measures. You can use the ALLSELECTED() function to remove filters from a column while retaining any filters from slicers or other visuals.
In order to better understand your demands and give the right solution, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |