Home Forums Data Warehousing Analysis Services How do I Calculate Benchmark Scores? RE: How do I Calculate Benchmark Scores?

  • October 1, 2015 at 7:41 am

    #1830758

    PB_BI (10/1/2015)

    I'm pretty sure you can do what you need using IF and/or SWITCH. Lot's of stuff out there for this:

    https://msdn.microsoft.com/en-us/library/gg492166.aspx

    https://msdn.microsoft.com/en-us/library/ee634824.aspx

    http://www.powerpivotpro.com/2012/06/dax-making-the-case-for-switch/

    http://sqlmag.com/sql-server-analysis-services/ssas-tabular-part-4-deep-dive-dax

    Thank you for the links. I came across IF yesterday and have been working on creating a statement to match my needs. It's going to be one long IF statement by the time it's done, but it is working so far. Thank you again!