Forum Discussion

fabconmvp's avatar
fabconmvp
Helper I
1 year ago
Solved

DAX Help

Hello everyone, I need help about dax. First of all ı have a table visualization in PBI. And below the image is example of how PBI visualization. I have 2 table. 1 Fact table and other DimDate tab...
Need Help
  • techies's avatar
    techies
    1 year ago

    Hi fabconmvp 

    Please check this

    Max_Weekly_Value_Per_Week =
    VAR CurrentWeek = SELECTEDVALUE('date'[Week])
    VAR WeeklyValues =
        CALCULATETABLE(
            SUMMARIZE(
                Sheet2,
                'date'[Week],
                Sheet2[Value]
            ),
            ALLEXCEPT('date', 'date'[Week])
        )

    RETURN
        MAXX(FILTER(WeeklyValues, 'date'[Week] = CurrentWeek), [Value])
fabconmvp's avatar
fabconmvp
Helper I
1 year ago

Hello,

İt doesn't work. The values doesn't change. Thank you for support.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

You are welcome.  Share the download link of the PBI file.