Something to consider when you as for support on DAX
To all that ask support about DAX, please consider the following: - in an Excel sheet, the result you get depends on the Excel formula written and the data - in Power BI, the result you get depends on the DAX formula written, on the data AND ON THE DATA MODEL Therefore, if you do not give details about the data model, together with the tables, it is impossible to support you correctly. And, by the way, if you say "I have a single table, not a data model so why bothering?", point is that Power BI is designed to work with a data model, so rethink your approach and make sure you create dimensions to connect to fact tables, bridge tables etc Best from one DAX supporter that is happy to help
