March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Experts,
I am having a request to take out a column of the value is exceeding a particular amount. So these are the condiions
1). if the value is >5 and if it is satisfied, then we need to take out the subproduct. This need to be a column. (ex- if (value>5,sub_product). how to write this in power bi dax?
2)Can we use this column to join data sources?
As long as it is a calculated column you will not have problems, remember that these are calculated only once until the next update of the report.
@Syndicate_Admin Thank you. How to write that dax function? If i write the aove, everything will get blank. What I wrote is , If ( value>5, subcat,blank())
is this correct?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
89 | |
73 | |
62 |
User | Count |
---|---|
140 | |
121 | |
107 | |
99 | |
94 |