Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
.
Solved! Go to Solution.
Hi @Allan-Mautante ,
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.
Hi @Allan-Mautante ,
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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |