Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@nisha_deepak - Create a column as below-
@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])))
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?
@nisha_deepak - Create a column as below-
thanks.It helps me to solve my problem
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |