Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
82 | |
79 | |
66 | |
49 | |
46 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
39 |