Forum Discussion

lauriedata's avatar
lauriedata
Resolver I
10 months ago
Solved

Alternative Dax for Calculated Column?

This calc column works in import mode by not DQ.  Tried to convert to a measure but can't due to mutltiple options within the categories.  Can someone help me find another way to convert this formula...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    10 months ago

      

    Try creating a calculated table for your dimension:

    Period Alias Dim =
    SUMMARIZE(
    v_flt_enrollment,
    v_flt_enrollment[ag_level],
    v_flt_enrollment[fiscal_nbr_in_year],
    "Period Alias",
    SWITCH(
    v_flt_enrollment[ag_level],
    "DAILY", "DAY " & v_flt_enrollment[fiscal_nbr_in_year],
    "WEEKLY", "WK " & v_flt_enrollment[fiscal_nbr_in_year],
    "MONTHLY", "MNTH " & v_flt_enrollment[fiscal_nbr_in_year],
    "QTR", "QTR " & v_flt_enrollment[fiscal_nbr_in_year],
    "YEARLY", "FY",
    "CHECK"
    )
    )

    Then use this table in your visual instead.

    lauriedata

Nabha-Ahmed's avatar
Nabha-Ahmed
Super User
10 months ago

Hi lauriedata

 

 

Create a Measure for Alias (for tooltip/labels)

If you only need it for display:

 

 
PeriodAliasTable =
ADDCOLUMNS(
SUMMARIZE(v_flt_enrollment, v_flt_enrollment[ag_level], v_flt_enrollment[fiscal_nbr_in_year]),
"Period Alias",
SWITCH(
TRUE(),
v_flt_enrollment[ag_level] = "DAILY", "DAY " & v_flt_enrollment[fiscal_nbr_in_year],
v_flt_enrollment[ag_level] = "WEEKLY", "WK " & v_flt_enrollment[fiscal_nbr_in_year],
v_flt_enrollment[ag_level] = "MONTHLY", "MNTH " & v_flt_enrollment[fiscal_nbr_in_year],
v_flt_enrollment[ag_level] = "QTR", "QTR " & v_flt_enrollment[fiscal_nbr_in_year],
v_flt_enrollment[ag_level] = "YEARLY", "FY",
"CHECK"
)
)

You can use this in data labels, tooltips, or matrix headers, but not directly on the X-axis (measures can’t be used as categorical axes).

Thanks 🌹✨

recieve me KUDO ✨


 

lauriedata's avatar
lauriedata
Resolver I
10 months ago

Thank you.  However,  it is for my x axis.