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.
hello , i'm new in powerbi and i'm stuck on basic dax query 😕 . I have three actions with a limit date and a state (true if it's done and false if it's not) , i would like to get the number of late actions so it need to be the sum of action 1 , 2 and 3 where the state is false and the date limit is < to the day.
in power apps i get the value with :
((state action 1 = false && 'date action 1' - Today() < 0 ) + (state action 2 = false && 'date action 2' - Today() < 0 ) ) + (state action 3 = false && 'date action 3' - Today() < 0 )
i've try thing like :
action en retard = SUM(Filter(QualityAlerts,QualityAlerts[state action 1] = false && QualityAlerts[Date Action 1] - TODAY() < 0)
but it tell me that sum fonction only accept to refer to a colum as argument .
if anyone could give me some tips it will save me ^^
@Maxime_leroy ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
here the numbre to display will be 5
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |