Excel Formula to Power Bi

[Anonymous]

Hi Folks,

Need your Help on  convert this Excel formula to Dax Power BI formula.

I already tried searching but doesn't work.

Validitor = Unique Value

Date/Hour= Date of Call

.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the formulas, if you still have doubts, please provide sample data and expected output.

blanks = ISBLANK( [Column] ) 

Validation = MAX( [column1] ) & MAX( [column2] )

Repeated Date & Time Call = 
IFERROR(
    blanks = TRUE(),
    CALCULATE(
        SUM([colum]),
        FILTER( )
    )
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Instead of giving the Excel formula, you can likely get the DAX expression you need from the community by providing a sample input table with the desired output column or table.  Input table should be in a copy/paste-able format (insert table).  Even better to provide a link to a pbix file with a mock up of your data.

Regards,

Pat