The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello All,
I have data , where i have Due days. i want to create a measure that only show me days which is >=1 .
@sandee
If you need a measure to count the record then:
Logic =
COUNTROWS(
FILTER(
'Table Aging,
Table Aging'[Days Due] >1
)
)
otherwise click on New Table in the modeling tab and paste
Logic Table =
FILTER(
'Table Aging,
Table Aging'[Days Due] >1
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank u Fowmy, it worked , but i got the complete table, what if i want one column only "Due Days >=1. should i use Value and Filter?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
94 | |
33 | |
30 | |
24 | |
21 |