Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Would be great if somebody could help with the following issue:
I have two fact sheets in my power BI (one for budget one for actual) and i have made a calculated table to link those two with project number:
Calculated Table:
Dim Project Numbers = DISTINCT(UNION(
ALL([BudgetTable]Column)
ALL([AcutalTable]Column)
))
This works fine. But I would like to add in this calculated table as well description of the projects. Descriptions are not exactly the same in actual and budget and not all budget projects already exist in actual already.
Therefore I would like to use:
Actual description if available,
if no actual description available, description from the budget.
Can somebody help to solve?
Thanks!!!!
BR
Solved! Go to Solution.
Hi @smiler2021 ,
My example data:
[AcutalTable]
[BudgetTable]
try this dax to creata a new column:
Column =
VAR _a =
CALCULATE(
MAX( 'AcutalTable'[description] ),
FILTER(
AcutalTable,
[ProjectID] = EARLIER( 'Dim Project Numbers'[ProjectID] )
)
)
VAR _b =
CALCULATE(
MAX( 'BudgetTable'[description] ),
FILTER(
BudgetTable,
[ProjectID] = EARLIER( 'Dim Project Numbers'[ProjectID] )
)
)
RETURN
IF( ISBLANK( _a ), _b, _a )
and result:
I put my pbix file in the attachment you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks you, great :-), it works.
BR,
Hi @smiler2021 ,
My example data:
[AcutalTable]
[BudgetTable]
try this dax to creata a new column:
Column =
VAR _a =
CALCULATE(
MAX( 'AcutalTable'[description] ),
FILTER(
AcutalTable,
[ProjectID] = EARLIER( 'Dim Project Numbers'[ProjectID] )
)
)
VAR _b =
CALCULATE(
MAX( 'BudgetTable'[description] ),
FILTER(
BudgetTable,
[ProjectID] = EARLIER( 'Dim Project Numbers'[ProjectID] )
)
)
RETURN
IF( ISBLANK( _a ), _b, _a )
and result:
I put my pbix file in the attachment you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |