Forum Discussion

sgsukumaran's avatar
sgsukumaran
Resolver II
7 years ago

Calculated table

I am trying to create a calculated table to bucket my measures for visuals. I have the budget , forecast and LY measures built already all I have to do is to show the measures in columns with labels....
Need Help
sgsukumaran's avatar
sgsukumaran
Resolver II
7 years ago

Anonymous - I have measures but not atrributes as Budget forecast and ly . How can i do that?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

sgsukumarancan you tell me what you want to do? 
I can't understand what is the problem :smileysad:

  • sgsukumaran's avatar
    sgsukumaran
    Resolver II
    7 years ago

    Anonymous. I have them as individual measures but they are grouped as budget or forecast

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi sgsukumaran,

       

      If it is convenient, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

       

      Best  Regards,

      Cherry

      • sgsukumaran's avatar
        sgsukumaran
        Resolver II
        7 years ago

        I figured this out. I ended up creating individual measures and bucketed them using the following dax.

         

        =SELECTCOLUMNS(
        {("Budget", "eComm","YTD", [Revenue $'s (eComm) YTD], [eComm Budget YTD Var %])
        }
        , "Metric", [Value1]
        , "Segment", [Value2]
        , "Period", [Value3]
        , "Dollars", [Value4]
        , "Variance", [Value5]
        )