Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nisha_deepak
Helper III
Helper III

Check date column is empty when creating a measure

I have a column named invoice_date which is of type date .Some times in invoice_date value will be empty.So, i want to create measure by  check whether that value is empty means i want add a value from another column (Policy_expiry_date) which is of type date else i have to take value from invoice_date itself.Plse help me.22.PNG

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@nisha_deepak - Create a column as below-

Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@nisha_deepak , Nor very clear

check blank

calculate(count(Table[Policy_expiry_date]), isblank(Table[invoice_date]))

 

check not blank

calculate(count(Table[Policy_expiry_date]), not(isblank(Table[invoice_date])))

33.PNG

 

checking invoice_date is empty or not ,if empty means take value from policy_expiry_date,

then put it in measure column.Is it possible.plse help me?

Anonymous
Not applicable

@nisha_deepak - Create a column as below-

Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])

thanks.It helps me to solve my problem

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.