Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am currently trying to create a column that states how long an item has been in stock, this is the formula I am using but I keep recieving the same error message:
I have tried to use other forum results to fix this such as: ensuring all column are the same data type (date), using a today column rather then the today() function, entering my filter as date() rather than just the date as dd/mm/yyyy, and a few others but nothing seems to be working.
Does anyone have any other suggestions?
Many thanks 🙂
Solved! Go to Solution.
or this
DealerStockDays =
IF (
AND (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
'00_StockData'[WSDate] = DATE ( 2173, 10, 13 )
),
"-",
IF (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
( TODAY () - '00_StockData'[WSDate] ) & "",
(
( VALUE ( '00_StockData'[R date] ) - '00_StockData'[WSDate] ) & ""
)
)
)
remove the quotes and use the functions FORMAT( TODAY(), "dd-MM-yyyy")
Apologies, I don't quite understand what you mean by this, is there any chance you could write it down for me so I can visualise what I need to add/remove.
Thank you in advance
you copy the measure and paste it here.
I can't copy it from a picture.
after that I'll show you what I mean.
pls try this
DealerStockDays =
IF (
AND (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
'00_StockData'[WSDate] = DATE ( 2173, 10, 13 )
),
"-",
IF (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
FORMAT(TODAY ()-'00_StockData'[WSDate],"dd-MM-yyyy"),
FORMAT( ( VALUE ( '00_StockData'[R date] ) - '00_StockData'[WSDate] ),"dd-MM-yyyy")
)
)
pls try this
DealerStockDays =
IF (
AND (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
'00_StockData'[WSDate] = DATE ( 2173, 10, 13 )
),
"-",
IF (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
FORMAT ( TODAY () - '00_StockData'[WSDate], "dd-MM-yyyy" ),
FORMAT (
( VALUE ( '00_StockData'[R date] ) - '00_StockData'[WSDate] ),
"dd-MM-yyyy"
)
)
)
or this
DealerStockDays =
IF (
AND (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
'00_StockData'[WSDate] = DATE ( 2173, 10, 13 )
),
"-",
IF (
'00_StockData'[R date] = DATE ( 2173, 10, 13 ),
( TODAY () - '00_StockData'[WSDate] ) & "",
(
( VALUE ( '00_StockData'[R date] ) - '00_StockData'[WSDate] ) & ""
)
)
)
This is the one 🙂 Thank you so much for all of your help!!
always happy to help
you need to add two quotes where the date is like this TODAY()&""
you have the date in two places
Thank you for that sugesstion, it has fixed the error issue but rather than completing the calculation it just shows me the sum ( as seen in the far right column). Do you know how to fix this?
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |