Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a requirment where the vendor wants a measure divded by the month number.
"Abs Perc of Error (Demand Forecast) / by the month number Example: Jan Abs Perc of Error (Demand Forecast) / 1, Feb Abs Perc of Error (Demand Forecast) / 2, etc"
When I try to create the DAX Measure the date denominator will not poplulate or if I try to use Quick Measure it wants to add sum
or another aggregation.
This a quick measure:
Hi @robarbie , how is your month number column formatted? As a whole number?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi Nathaniel,
It is formatted as a whole number.
Thanks,
Rochelle
Hi @robarbie , since DAX needs to know which row to use in a table, it won't let you put in a "naked" column because there are multiple values. I typically use MAX(), but most of the time you could use MIN() as well. Since in a typical calculated column, the engine knows what row it is on the MAX() works fine.
Proud to be a Super User!
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |