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

Kedar_Pande's avatar
Kedar_Pande
Super User
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

  • lauriedata's avatar
    lauriedata
    Resolver I
    10 months ago

    Thank you. After the table, I had to create duplicate columns for fiscal nbr and for ag_level in both my tables and merge them in order to join on both fiscal nbr in year and ag_level.  Is there an easier way to do joins on multiple fields?  Many thanks again for your time and efforts.