Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?