If statement with date

ashely_nave — Mon, 11 Dec 2023 21:58:36 GMT

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

Calculation Date = if(isblank([Completed on]),[Current Date],[Completed on].[Date]). The point of this one is that to measure the downtime to date, I have to have an end. So if the work order in not completed, it returns the current date. This one works well.

I am new to PowerBi so I am stumbling through this.

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.

Re: If statement with date

vicky_ — Tue, 12 Dec 2023 00:00:12 GMT

Please try the following formula:

Start Date = var startOfThisMonth = EOMONTH(TODAY(), -1) + 1 return IF('Table'[created_at] < startOfThisMonth, startOfThisMonth, 'Table'[created_at])

Re: If statement with date

ashely_nave — Tue, 12 Dec 2023 13:33:20 GMT

Thank you so much!

topic Re: If statement with date in DAX Commands and Tips

If statement with date

Re: If statement with date

Re: If statement with date