Wednesday, 11 November 2020

POWER BI - DAX - New Column for Flag

 when you wants to create a new column which will be used as flag.

Create a new column and use the below formula 

Flag = IF ( X1=X2 , "Yes","No")

Example ..

FLAG = IF(WC_ASSAI_TRANSMITTAL_F[LATEST_REV]=WC_ASSAI_TRANSMITTAL_F[REVISION_CODE], "Y","N")


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...