Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi - could someone explain what was done incorrectly with this measurement? Power BI is stating my syntax for 'StartofQuarter' is incorrect.
Solved! Go to Solution.
Hi @kl8818 ,
At my knowledge, the STARTOFQUARTER function expects a date column as an argument, not a single date value.
Please try something like this
Agree / Strongly Agree QTR (%) =
VAR CurrentDate = TODAY()
VAR CurrentYear = YEAR(CurrentDate)
VAR CurrentQuarter = QUARTER(CurrentDate)
VAR _StartOfQuarter =
SWITCH(
TRUE(),
CurrentQuarter = 1, DATE(CurrentYear, 1, 1),
CurrentQuarter = 2, DATE(CurrentYear, 4, 1),
CurrentQuarter = 3, DATE(CurrentYear, 7, 1),
CurrentQuarter = 4, DATE(CurrentYear, 10, 1)
)
RETURN ***
Best Regards,
Wearsky
Hi @kl8818 ,
At my knowledge, the STARTOFQUARTER function expects a date column as an argument, not a single date value.
Please try something like this
Agree / Strongly Agree QTR (%) =
VAR CurrentDate = TODAY()
VAR CurrentYear = YEAR(CurrentDate)
VAR CurrentQuarter = QUARTER(CurrentDate)
VAR _StartOfQuarter =
SWITCH(
TRUE(),
CurrentQuarter = 1, DATE(CurrentYear, 1, 1),
CurrentQuarter = 2, DATE(CurrentYear, 4, 1),
CurrentQuarter = 3, DATE(CurrentYear, 7, 1),
CurrentQuarter = 4, DATE(CurrentYear, 10, 1)
)
RETURN ***
Best Regards,
Wearsky
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |