Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, im trying to sum all the items that was fall under the "True" statement. Ive already have a measure that will calculate the score so if the employee pass the metric he got 5 else 0 on each metrics and that measure was names "S.(measurename)". However, some of my calculations have Year to date calculation from quick measure and im getting this error.
"Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."
@xRTP , this measure is not using time intelligence. Seem like it should work
for TI
you can try like
calculate([Test Total], datesytd(Date[Date]))
or
calculate(Sumx(values(Date[Date]) , [Test Total], datesytd(Date[Date]))
You should use the date table joined with the date column of your table
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Tried this and still got the same error
Hello thanks for the reply, but i dont have any date table, the dates are already part of the raw data. Is it gonna work?
User | Count |
---|---|
87 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |