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.

     

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