Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
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:]
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:]
Thanks for quick solutions...
It's work
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |