Tuesday, 22 December 2020

POWER BI - DAX - FIND()

 When we are trying to search for a specific character or latter from a Word then we can use FIND () function.

Lets say we need to find '/' from COLUMN value, if it find the character then it would return 1 else Null. 

FIND("/",COLUMN,1,BLANK())


Happy learning !!

No comments:

Post a Comment

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...