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 try to count my lost customers and my visual looks like
where Lost = IF([Netamount_mon])=BLANK(),1,0) and year and month come from a date table.
Since customer A first purchased date is Oct 2021, it should not count as lost.
I tried IF('Date'[Date] < [first purchased date], BLANK(),...), but the date table does not work with IF function.
Happy for any idea.
Thanks a lot
Solved! Go to Solution.
Works fine in may case: (right the table via dimDate)
Can you post your data model please?
Proud to be a Super User!
Works fine in may case: (right the table via dimDate)
Can you post your data model please?
Proud to be a Super User!
aaaahhhh, my relationship was not correct. Thank so much. Now it works. 😇😇😇😇😇😇😇😇😇
Thanks for your help. When I try your DAX I receive the same error 😞
My Date comes from a different Date Table. This is exactly where I struggle
I should mention that I tried it as a measure
You have to use the by VAR firstime the date column from "6_lost"
VAR currenttime you have to use the date column from "6_lost"
Proud to be a Super User!
My solution: Tabelle2
Via DAX, your old value:
Lost = IF(sum(Tabelle2[Amount])>0,0,1)
Lost_new =
VAR firsttime = CALCULATE(min(Tabelle2[Date]),FILTER(ALL(Tabelle2),Tabelle2[Amount]>0))
VAR currenttime = MAXX(Tabelle2,Tabelle2[Date])
VAR varnew = IF(sum(Tabelle2[Amount])= 0 && currenttime>firsttime,1,0)
RETURN varnew
Proud to be a Super User!
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |