Forum Discussion

Anna123456's avatar
Anna123456
Frequent Visitor
3 years ago
Solved

Get column based on date and title

Hello,  I have a question. I want to get the value of "visit24hrs" for today for each title in my report. I try to use this formula:    result = CALCULATE(SUM(AnalyticsView[Visits24h]), FILTER(A...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anna123456 

    are you expecting something like:

    result = 
MAXX(
    FILTER(
        ALL(AnalyticsView), 
        AnalyticsView[Date] = TODAY()
    ),
    AnalyticsView[Visits24h]
)
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

You use this as a calculated column, right?

result = CALCULATE(SUM(AnalyticsView[Visits24h]), FILTER(ALL( AnalyticsView), (today() = AnalyticsView[Date])))