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.
Hi guys,
I don't understand how to create an if, for each line of my table to verify that Table1[Date] is < Today. If Table1[Date] is < Today, DUE, Table1[Date].
I need to show this in the table, so I need to summarize all values in DUE, and show all lines dates for else.
I tried create this dax, but not working
How do I do this?
Date | Value |
DUE | 7869 |
01/10/2021 | 90 |
01/02/2021 | 100 |
02/07/2021 | 45 |
Solved! Go to Solution.
@twister8889 , Create a new column
if([Date] < today(), "Due", [Date] & "" )
@twister8889 , Create a new column
if([Date] < today(), "Due", [Date] & "" )
First of all, thank you so much for your answer...
Its working now, thanks
So in this case, I need to use Column and not Measure!!!!! ok, thank you. Its better create this in power query ?
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |