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.
Measure:
Thank you.
Hi @jnet
Thanks for reaching out to us.
I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
the first argument of DATESBETWEEN and DATEADD shall be a Date column. Try this:
L13W FA KG =
CALCULATE(
AVERAGEX(
'TM1 Facts'[Wk Start],
CALCULATE(Baseline[FA KG])
),
DATESBETWEEN(
'Date'[Date],
DATEADD(
Date'[Date],
-91,
DAY
),
DATEADD(
Date'[Date],
1,
DAY
)
)
)
Copying above suggestion, I got below error so I tried changing AverageX to Average and Baseline[FA KG] from measure to column to get a result... but it still looks incorrect.
Thanks. This is the error message I get when taking above suggestion:
indeed the column needs to be converted to a table, try this:
L13W FA KG =
CALCULATE(
AVERAGEX(
VALUES('TM1 Facts'[Wk Start]),
CALCULATE(Baseline[FA KG])
),
DATESBETWEEN(
'Date'[Date],
DATEADD(
Date'[Date],
-91,
DAY
),
DATEADD(
Date'[Date],
1,
DAY
)
)
)
User | Count |
---|---|
140 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |