Forum Discussion
Dynamic Measure Required with two slicer
Hi Folks,
I'm trying to develop the dashboard by comparing two months and their uses of two slicers.
I prepared the dashboard using Excel Formulas. please help to develop Power-BI
As the Raw data is attached Excel is available. please refer it
Google Drive Link for Excel File
Please feel free to contact for more info if required.
RAW Data
| Period | Account | Value X | Value Y | Value Z |
| Fix | Tata | 4 | 3 | 5 |
| Fix | Birla | 6 | 7 | 8 |
| Fix | Adani | 7 | 8 | 9 |
| Fix | RIL | 8 | 9 | 10 |
| Fix | Tata | 9 | 10 | 11 |
| Fix | Birla | 10 | 11 | 12 |
| Jan | Adani | 11 | 12 | 13 |
| Jan | RIL | 12 | 13 | 14 |
| Jan | Tata | 13 | 14 | 15 |
| Jan | Birla | 14 | 15 | 16 |
| Jan | Adani | 15 | 16 | 17 |
| Feb | RIL | 16 | 17 | 18 |
| Feb | Tata | 17 | 18 | 19 |
| Feb | Birla | 18 | 19 | 20 |
| Feb | Adani | 19 | 20 | 21 |
| Feb | RIL | 20 | 21 | 22 |
| March | Tata | 21 | 22 | 23 |
| March | Birla | 22 | 23 | 24 |
| March | Adani | 23 | 24 | 25 |
| March | RIL | 24 | 25 | 26 |
| March | Tata | 25 | 26 | 27 |
| March | Birla | 26 | 27 | 28 |
| March | Adani | 27 | 28 | 29 |
| April | RIL | 28 | 29 | 30 |
| April | Tata | 29 | 30 | 31 |
| April | Birla | 30 | 31 | 32 |
| April | Adani | 31 | 32 | 33 |
| April | RIL | 32 | 33 | 34 |
| April | Tata | 33 | 34 | 35 |
Regards,
MOHIT
Hi, I could not access to the googledrive, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file whether it suits your requirement.
Fix: = CALCULATE ( SUM ( Data[Value] ), REMOVEFILTERS ( Period ), Period[Period Number] = 0 )Selected period: = SUM( Data[Value])OFFSET function (DAX) - DAX | Microsoft Learn
Previous period: = VAR _previousperiodnumber = MAX ( Period[Period Number] ) - 1 VAR _condition = _previousperiodnumber <> 0 RETURN IF ( _condition, CALCULATE ( SUM ( Data[Value] ), OFFSET ( -1, ALL ( Period[Period Number], Period[Period] ), ORDERBY ( Period[Period Number], ASC ) ) ) )Selected period fix: = [Selected period:] - [Fix:]Diff: = [Selected period:] - [Previous period:]
2 Replies
- Jihwan_KimSuper User
Hi, I could not access to the googledrive, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file whether it suits your requirement.
Fix: = CALCULATE ( SUM ( Data[Value] ), REMOVEFILTERS ( Period ), Period[Period Number] = 0 )Selected period: = SUM( Data[Value])OFFSET function (DAX) - DAX | Microsoft Learn
Previous period: = VAR _previousperiodnumber = MAX ( Period[Period Number] ) - 1 VAR _condition = _previousperiodnumber <> 0 RETURN IF ( _condition, CALCULATE ( SUM ( Data[Value] ), OFFSET ( -1, ALL ( Period[Period Number], Period[Period] ), ORDERBY ( Period[Period Number], ASC ) ) ) )Selected period fix: = [Selected period:] - [Fix:]Diff: = [Selected period:] - [Previous period:]- mohitchughFrequent Visitor
Thanks for quick solutions...
It's work