Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |