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.

     

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.