Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hi,
Struggling with this. How can i pass a measure into an if/switch stament.
This will be used to format colours - not sure how to get around this
Measure = SWITCH(TRUE() , 'Calculations Table'[DSA%_Late] <> 'Construct_Supplier Ruling'[DSA_Amb_Target} & 'Construct_Supplier Ruling'[DSA_Grn_Target] , 3 )
Hi, @Jackbaz99
Invalid code can't help us understand your problem, please try to use pictures and text to describe your needs.
Best Regards,
Community Support Team _ Eason
Measures should never be preceded with the table name they reside in. On the other hand, columns should always be. Please stick to this rule because if you don't, others will have (and do have!) a very hard time reading and understanding the code. Thanks.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 9 | |
| 6 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 21 | |
| 14 | |
| 11 | |
| 6 | |
| 5 |