Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to pull values from two distinct tables.
Measures used are
SUM(
salesorders[NetChangeinMRCc]),
FILTER(salesorders,
salesorders[CreatedBy] <> "KR"
&& salesorders[CreatedBy] <> "SH")
)
Sum(Budget[Budget Monthly]),
CalendarTable[dDate])
My mappings look like this:
How do I create a visualization using both since they are based on differing date structures?
Thanks in advance!
Solved! Go to Solution.
Solved it! I added a column to the Budget table with an actual date of the 1st of each month. Then I was able to map that date field to the date field in the Calendar table and it works beautifully!
Sometime you just have to ask the question out loud before you think of the answer!
Solved it! I added a column to the Budget table with an actual date of the 1st of each month. Then I was able to map that date field to the date field in the Calendar table and it works beautifully!
Sometime you just have to ask the question out loud before you think of the answer!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |