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 peeps,
i try to describe my issue as good and as clean as possible:
I imported a dataset from SAP via Import 2.0.
Therefore i have an "amount" column from which the current numbers are pulled when specific items are pulled in (lets say sth. like Storecodes/Countries,....).
Additionally, we have 2 years to take a look on (Current Year = CY, Last Year = LY). Plus, there is a tag thats needs to be pulled in for the fiscal year. Meaning the values for LY needs to be defined by FiscalYear20, the ones for CY by FiscalYear21. Furthermore, a "Week" per year is defined that needs to be connected to the right fiscal year. Example: 2001 (first week of 2019!) needs to be calculated by amount, FiscalYear(19) and so on (around 4 items).
I defined different measure for visualisations that work perfectly. Now i want to calculate a YoY performance and i don't know the best way of doing that. I tried with Calculate(), but i know it does not work with measures. So I tried calculate and filter, but suddenly, i was not sure and was thinking if it is better to define 2 seperate measures and calculate them afterwards as a variance/difference.
Solved! Go to Solution.
Hi @NovaBI ,
Please check if the following documentations can help you. If no, please provide some sample data and your expected result, later will provide the suitable formula for your scenario.
POWER BI – YEAR OVER YEAR (YOY) REPORTS USING SAMEPERIODLASTYEAR
Complex Filter Conditions In Power BI Reports Using Visual-Level Filters And Measures
Favorite Quick & Easy DAX: Multiple FILTER Criteria
Best Regards
Rena
forgot the minus here:
I tried sth. like XYZ =
Calculate(Sum(table1)[Amount]), Filter[table1,table1[CY Testcode])
%
Calculate(Sum(table1)[Amount]), Filter[table1,table1[PY Testcode])
Hi @NovaBI ,
Please check if the following documentations can help you. If no, please provide some sample data and your expected result, later will provide the suitable formula for your scenario.
POWER BI – YEAR OVER YEAR (YOY) REPORTS USING SAMEPERIODLASTYEAR
Complex Filter Conditions In Power BI Reports Using Visual-Level Filters And Measures
Favorite Quick & Easy DAX: Multiple FILTER Criteria
Best Regards
Rena
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |