Forum Discussion

krichmond's avatar
krichmond
Icon for Helper IV rankHelper IV
4 years ago

I need help modifying an existing DAX formula

I need help modifying an existing DAX formula that sits under a field called "Media Due" so that it looks at this field and returns different values depending on what the value of that field is. How ...
DAX Formulas
krichmond's avatar
krichmond
Icon for Helper IV rankHelper IV
4 years ago

daXtreme - Easy for a super user I am sure it is easy. However, I am brand new to Power BI. Any assisntance you can provide in tweaking the DAX would be greatly appreciated,.

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

Well, as I said, it's easy to do. First, the intellisense tells you that you don't have a variable called YearNumber. But you do have StartDate which in fact is the year number, right? So, you have to decide on one of them and then replace the other. Second, since you did not tell us what your table was called, I used the general term "T" and also the column name "Media Type." You have to adjust this to your model...

  • krichmond's avatar
    krichmond
    Icon for Helper IV rankHelper IV
    3 years ago

    daXtreme - I ended up trying it this way and there aren't any errors. However, when looking at the report itself, nothing is populating in the "Media Due" field which contains the DAX formula. Any idea why this is happening?

     

     

    Media Due = switch(true(),
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 1 && dimstartdate[Yearnumber] = 2023, "12/14/2022",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 2 && dimstartdate[Yearnumber] = 2023, "1/19/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 3 && dimstartdate[Yearnumber] = 2023, "2/15/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 4 && dimstartdate[Yearnumber] = 2023, "3/23/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 5 && dimstartdate[Yearnumber] = 2023, "4/20/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 6 && dimstartdate[Yearnumber] = 2023, "5/17/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 7 && dimstartdate[Yearnumber] = 2023, "6/21/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 8 && dimstartdate[Yearnumber] = 2023, "7/20/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 9 && dimstartdate[Yearnumber] = 2023, "8/23/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 10 && dimstartdate[Yearnumber] = 2023, "9/20/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 11 && dimstartdate[Yearnumber] = 2023, "10/18/2023",
    MAX(mv_perfex[mediatype]) = "Digital" && dimstartdate[monthnumber] = 12 && dimstartdate[Yearnumber] = 2023, "11/21/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 1 && dimstartdate[Yearnumber] = 2023, "12/7/2022",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 2 && dimstartdate[Yearnumber] = 2023, "12/7/2022",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 3 && dimstartdate[Yearnumber] = 2023, "1/6/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 4 && dimstartdate[Yearnumber] = 2023, "2/13/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 5 && dimstartdate[Yearnumber] = 2023, "3/14/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 6 && dimstartdate[Yearnumber] = 2023, "4/10/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 7 && dimstartdate[Yearnumber] = 2023, "5/11/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 8 && dimstartdate[Yearnumber] = 2023, "6/9/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 9 && dimstartdate[Yearnumber] = 2023, "7/10/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 10 && dimstartdate[Yearnumber] = 2023, "8/11/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 11 && dimstartdate[Yearnumber] = 2023, "9/11/2023",
    MAX(mv_perfex[mediatype]) = "Direct Mail" && dimstartdate[monthnumber] = 12 && dimstartdate[Yearnumber] = 2023, "10/4/2023",
    BLANK())