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'm attempting to create a column/measure that captures what weeknum a certain date is in but i'm not receiving the correct answer. Below is my column and measure formula:
Column
Est. Close Date Week = WEEKNUM(Close Date.[Date],2)
Measure
Est. Close Date WeekNum = WEEKNUM(SUM(Close Date]),2)
Why am I not receiving the correct answer?
Solved! Go to Solution.
I figured out the issue. There were multiple installments that had the same closing date whcih is what was leading to the wrong values being displayed.
I figured out the issue. There were multiple installments that had the same closing date whcih is what was leading to the wrong values being displayed.
Hi @mikep7521
There is something wrong with your formula, please look at the following test and correct your formula.
Calculated column
weeknum = WEEKNUM([Close Date],2)
Measure
Measure = WEEKNUM(MAX([Close Date]),2)
Best Regards
Maggie
Perhaps the "." after the table name cause the issue, also enclose the table name in single quote as your table namehas space in it.Try the below one.
Column
Est. Close Date Week = WEEKNUM('Close Date'[Date],2)
Thanks
Raj
The I recieve an error code: The syntax for '[Date]' is incorrect. (DAX(WEEKNUM(Installment[Close_Date][Date],2))).
Your formula is not correct. Can you share the snapshot of your formula? Or Share the exact formula you used.
Thanks
Raj
Below you will see the formula I used, as well as the output of that formula. The very first row with the date of 1/15/18 should be week number 3 but I'm receiving 12. why is this?
Hi @mikep7521,
Can you do it in the back end, or does it need to be a measure? I would just use "Column from Example" in Query Editor; it should pick up the pattern after a few entries.
I tried that route and I'm still receiving outputs that are wrong.
It does not need to be a column
Could you please elaborate? I'm not familiar with what you are referencing.
I know, thats why I'm posting on the forum. I shared the formulas above, those are the two formulas I've tried.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |