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.
how to deal "Blank" in card condition filter base
2 columns
Date:
Time:
data:
Condition is when i show "time" in card with today date fliter if there is no data card show "Blank"
how to deal with Blank to <Space> or <Null>
I tried
Measure = IF(CALCULATE(distinctcount('MasterExchange Rates'[Date]),'MasterExchange Rates'[Date] = TODAY()-1), TRUE(CALCULATE(MAX('MasterExchange Rates'[Time]),'MasterExchange Rates'[Date] = TODAY()-1) ,FALSE()))
Solved! Go to Solution.
Hi @muhammadtabish ,
You can take a look at following link to handle blank value in dax:
Regards,
Xiaoxin Sheng
Hi @muhammadtabish ,
You can take a look at following link to handle blank value in dax:
Regards,
Xiaoxin Sheng
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |