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.
Hi, I have a requirement here:
I have data like below:
I need the output in Power BI as:
There will be a slicer to select year. When I select Year as 18 in the slicer, it should list data only for Year 2018 where the Profit for year 2018 is compared with Profit of 2017 and added into a column. It should be seen like below:
Any Ideas?
Solved! Go to Solution.
May be this Column
Column = VAR Previous_Year = CALCULATE ( SUM ( Table1[Profit] ), ALLEXCEPT ( Table1, Table1[Product] ), SAMEPERIODLASTYEAR ( Table1[Date] ) ) RETURN IF ( NOT ( ISBLANK ( Previous_Year ) ), Table1[Profit] - Previous_Year )
Try this measurE
Measure = VAR Previous_Year = CALCULATE ( SUM ( Table1[Profit] ), ALLEXCEPT ( Table1, Table1[Product] ), SAMEPERIODLASTYEAR ( Table1[Date] ) ) RETURN SUM ( Table1[Profit] ) - Previous_Year
Hi Zubair,
Your code works great for a Measure. Thanks for it. I actually need to create a new Column with these values, so that I can use the column for further calculations. Can you think of DAX to create new column for same requirement ???
May be this Column
Column = VAR Previous_Year = CALCULATE ( SUM ( Table1[Profit] ), ALLEXCEPT ( Table1, Table1[Product] ), SAMEPERIODLASTYEAR ( Table1[Date] ) ) RETURN IF ( NOT ( ISBLANK ( Previous_Year ) ), Table1[Profit] - Previous_Year )
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |