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.
Solved! Go to Solution.
try like
Measure =
var _Date =
DATE(
YEAR(TODAY())-1,
MONTH(TODAY()),
DAY(TODAY())
)
+
TIME(
HOUR(NOW()),
MINUTE(NOW()),
SECOND(NOW())
)
+
dayInc
RETURN
CALCULATE(
COUNT(customer[ID]),
dateTable[Date] >= _Date
)
OK, it doesn't look like you even have three parameters for your first DATE function. The second parameter looks to be a return from a DATE function. This is all bad.
CALCULATE(
COUNT(customer[ID]),
DATE(
YEAR(TODAY())-1,
DATE(
YEAR(TODAY())-1,
MONTH(TODAY()),
DAY(TODAY())
)
+
TIME(
HOUR(NOW()),
MINUTE(NOW()),
SECOND(NOW())
)
+
dayInc
)
)
When i useed your dax that give error message one "day" parameter is missing.
I need use this date like this
CALCULATE(
COUNT(customer[ID]),
DATE(
YEAR(TODAY())-1,
MONTH(TODAY()),
DAY(TODAY())
)
+
TIME(
HOUR(NOW()),
MINUTE(NOW()),
SECOND(NOW())
)
+
dayInc
)
but this give this error message.
"The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column."
@az38
Yes try fillter function but thi not work give over count.
when i use this Dax this work good with Date but not with time. I just need help work with time
try like
Measure =
var _Date =
DATE(
YEAR(TODAY())-1,
MONTH(TODAY()),
DAY(TODAY())
)
+
TIME(
HOUR(NOW()),
MINUTE(NOW()),
SECOND(NOW())
)
+
dayInc
RETURN
CALCULATE(
COUNT(customer[ID]),
dateTable[Date] >= _Date
)
I want this to be count.
For Exmaple: Today Date and Time will be: 09-05-2020 17:25 ---- I want count of last year till same time : 11 -05-2029 till 17:25.
That measure i am using it work with date level but not with time. so can you plz help on this
@az38 Thanks it work when i use like this way
so, now its ok?
if so, please, mark appropriated solution to close the topic
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |