Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Excel Formula to Power Bi

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

 

 

.

Need Help
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

     

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.