The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have linked to our new maintenance system in PowerBi. I am trying to automate the machine downtime metric. In the calculation date field, I have an IF statement that says
I have a field [created.on]. I need a statement that says if [created.on] is before the current month, return the first date of the current month, if not return [created.on]. The reason for this is that downtime is measured by a monthly metric. So as the work order was started on 11/26, the downtime from 11/26-11/30 would be counted on the November downtime report.
Please let me know if anything is not clear. Any help would be greatly appreciated.
Solved! Go to Solution.
Please try the following formula:
Start Date =
var startOfThisMonth = EOMONTH(TODAY(), -1) + 1
return IF('Table'[created_at] < startOfThisMonth, startOfThisMonth, 'Table'[created_at])
Thank you so much!
Please try the following formula:
Start Date =
var startOfThisMonth = EOMONTH(TODAY(), -1) + 1
return IF('Table'[created_at] < startOfThisMonth, startOfThisMonth, 'Table'[created_at])