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 to display selected quarter sales by marketing unit and previous quarter sales with the variance , i am not able to find variance.
Note : If user will select Q1 of FY 2017-2018 than Q4 value of 2016-2017 should also be shown with the variance.
Regards
Solved! Go to Solution.
Hi @Anonymous,
For variance calculation, you can choose the "variance" function to aggregate values under the list.
To display selected quarter sales and previous quarter sales, you may need to add an index column to specify the ascending order of the Year-Quarter. Also, you need an extra table to list all available selections uniquely, like below. Later, you should drag [Quarter] field from this table into slicer.
Create such a measure, add it to visual level filters and set its value to 1.
Measure = IF ( SELECTEDVALUE ( Table4[Index] ) = SELECTEDVALUE ( 'Slicer Table'[Index] ) || SELECTEDVALUE ( Table4[Index] ) = SELECTEDVALUE ( 'Slicer Table'[Index] ) - 1, 1, 0 )
Best regards,
Yuliana Gu
Hi @Anonymous,
For variance calculation, you can choose the "variance" function to aggregate values under the list.
To display selected quarter sales and previous quarter sales, you may need to add an index column to specify the ascending order of the Year-Quarter. Also, you need an extra table to list all available selections uniquely, like below. Later, you should drag [Quarter] field from this table into slicer.
Create such a measure, add it to visual level filters and set its value to 1.
Measure = IF ( SELECTEDVALUE ( Table4[Index] ) = SELECTEDVALUE ( 'Slicer Table'[Index] ) || SELECTEDVALUE ( Table4[Index] ) = SELECTEDVALUE ( 'Slicer Table'[Index] ) - 1, 1, 0 )
Best regards,
Yuliana Gu
this syntax assumes that you have a calendar table marked as date table, as described here
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
Last Quarter Sales = CALCULATE([Sales], DATEADD(Calendar[Date],-1,QUARTER))
Delta Last Quarter = [Sales]-[Last Quarter 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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |