The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I need to say
AVB = IF('SageFunctCodes$'[type]="Cost",Budgets[Budget]-Transactions[Actual],IF('SageFunctCodes$'[Type]="Revenue",Transactions[Actual]-Budgets[Budget],0))
but in a measure. When I try to copy the code in the measure it does not recognise the SageFunctCodes columns. How would I go about replicating the above in a Dax measure.
Thanks
C
Solved! Go to Solution.
Found
AvB = IF(COUNTROWS(VALUES( 'SageFunctCodes$'[Type] ))=1, IF(VALUES( 'SageFunctCodes$'[Type] ) = "Cost", Budgets[Budget]-Transactions[Actual], IF(VALUES( 'SageFunctCodes$'[Type] ) = "Revenue", Transactions[Actual]-Budgets[Budget]) ),Transactions[Actual]-Budgets[Budget])
This works.
Found
AvB = IF(COUNTROWS(VALUES( 'SageFunctCodes$'[Type] ))=1, IF(VALUES( 'SageFunctCodes$'[Type] ) = "Cost", Budgets[Budget]-Transactions[Actual], IF(VALUES( 'SageFunctCodes$'[Type] ) = "Revenue", Transactions[Actual]-Budgets[Budget]) ),Transactions[Actual]-Budgets[Budget])
This works.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
240 | |
125 | |
122 | |
82 | |
80 |