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.
Hello together,
first time posting here, cause i have nobody in my company to ask about power bi and DAX.
I calculated a filtert measure in my table for every month, which works fine, but now i need to divide this Measure for every month by a calculated number of days which come from another created Table.
Solved! Go to Solution.
I found a way to a solution.
So normally you would have the "month" in the visual and then you could use something like:
VAR __Month = MAX('Table'[Month])
RETURN
Well that would only give me the result for last Month (12) which is the max number.
[Arbeitstage]
MonthOfDate | Arbeitstage | Krankentage | Plantage |
1 | 20 | 1 | 19 |
2 | 22 | 0,5 | 21,5 |
3 | 21 | 2 | 19 |
[gf effort]
MonthOfDate | .. | .. | Revenue |
1 | .. | .. | 10000 |
2 | ... | .. | 7890 |
1 | .. | .. | 5000 |
...
these are my tables.
VAR __Month = MAX('Table'[Month])
RETURN
I found a way to a solution.
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |