Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi - I was wondering if someone could help me with this. I got 3 tables: F1, F2 and F3. Each of them got a date column and a value column. I'd like to create a measure that sum all the values in F1 that got the date 01/01/2023 together with all the values in F2 that got the date 01/01/2023 and all the values in F3 with the date 01/01/2023. I tried the below DAX formula, but can't get it right. Would anyone be able to help? 😊
@VTork Try:
2023 Measure =
VAR __Date = DATE(2023,1,1)
VAR __F1 = SUMX(FILTER(ALL('F1'),[Date] = __Date),[Value])
VAR __F2 = SUMX(FILTER(ALL('F2'),[Date] = __Date),[Value])
VAR __F3 = SUMX(FILTER(ALL('F3'),[Date] = __Date),[Value])
VAR __Result = __F1 + __F2 + __F3
RETURN
__Result
Hi @Greg_Deckler - thank you for getting back to me so quickly!
Sorry I'm still quite new to Power Bi, tried to follow your guidance but didnt get it quite right....
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |