Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a formula created using DAX in my table but something is not Ok with the final result and i don't know why.
I have this Column that cames from an Excel file, info inside was input with a PowerApps app. But the second column was added in PowerBi
This is basically the formula that I'm using
Column from datebase
Calculated column
I have tested with some of my files.
With my experience, try check whether there is spaces after the text e.g. "Pend ", I have met that a few times.
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @CP0822,
You have the parênteses of the if clause in the incorrect place, you are closing the IF clause before the - 2.
Try this
Consump_time =
IF (
Table1[Consumption_pre_status] = "Pend",
BLANK (),
( Table1[Latest Consump date] - Table1[Contract_date] )
- 2
* (
ROUNDDOWN (
( Table1[Latest Consump date].[Date] - Table1[Contract_date] ) / 7,
0
)
)
)
As you can see on the image below this new calculation returns expected result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
130 | |
129 | |
102 | |
98 |