I am trying to convert the attached Cognos case statement into a DAX statement, in a caclulated column. I have been trying for a whole using a mix of if(and and if(isblank and so on but simply cannot get my head around it and hence can't get it written to produce the correct ...
In fact, you really shouldn’t have your data spread across multiple sheets. The correct data format is tabular. I hope that points you in the right direction. Reply Jared December 16, 2020 at 12:08 am I agree! The problem is the Excel file is coming from Cognos and needs to be ...