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!
Please help I don't know how to convert this expression to dax:
" If Amort OB is greater than equal to GL OB between the due date and the curing period then '1' else '0'."
Thanks!
Solved! Go to Solution.
Hi @Peejz_Jalmasco ,
Try this:
Measure =
IF (
MAX ( 'Table'[Amort OB] ) >= MAX ( 'Table'[GL OB] )
&& MAX ( 'Table'[Date] ) >= *** //due date
&& MAX ( 'Table'[Date] ) <= ***, //curing peiod
1,
0
)
Column =
IF (
'Table'[Amort OB] >= 'Table'[GL OB]
&& 'Table'[Date] >= "due date"
&& 'Table'[Date] <= "curing peiod",
1,
0
)
If there are some errors, please give me the screenshots and some sample data.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Peejz_Jalmasco ,
Try this:
Measure =
IF (
MAX ( 'Table'[Amort OB] ) >= MAX ( 'Table'[GL OB] )
&& MAX ( 'Table'[Date] ) >= *** //due date
&& MAX ( 'Table'[Date] ) <= ***, //curing peiod
1,
0
)
Column =
IF (
'Table'[Amort OB] >= 'Table'[GL OB]
&& 'Table'[Date] >= "due date"
&& 'Table'[Date] <= "curing peiod",
1,
0
)
If there are some errors, please give me the screenshots and some sample data.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |