Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I want to create a formula in DAX, which create a case/ condition as column - status (New, updated,unchanged).
that should compare between today vs yesterday (latest date as of yesterday) and primary key, sales )
Let me know if the above question/query is still unclear.
Thank you very much for the support.
Greeting,
Solved! Go to Solution.
@amitchandak thank you for the code.
if in the above scenario, if I want to find the delta of sales with reference today(the one which I filter) and yesterday (with reference to filtered)- what could you suggest to write in dax.
thank you in advance.
Hi @surajbh ,
The reference could be like this:
Reference =
VAR _last =
MAXX (
FILTER (
'Table',
[Date]
= EARLIER ( 'Table'[Date] ) - 1
&& [Primary key] = EARLIER ( 'Table'[Primary key] )
),
[Sales]
)
return
[Sales] - _last
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yingjl thank you for the support.
if in the above-given scenario, the user has the possibility of filtering or choosing ( two dates- one to another date ), that will determine the status of the primary key.
How could you write DAX.
thank you in advance for the support.
@surajbh , Try a new column
new column =
var _last = maxx(filter(Table, [Date] =earlier([Date])-1 && [primary key] =earlier([primary key])),[sales])
return
Switch(true() ,
isblank(_last) , "New" ,
_last <> [sales] , "Updated"
,"same"
)
@amitchandak thank you for the code.
if in the above scenario, if I want to find the delta of sales with reference today(the one which I filter) and yesterday (with reference to filtered)- what could you suggest to write in dax.
thank you in advance.
Hi @surajbh ,
The reference could be like this:
Reference =
VAR _last =
MAXX (
FILTER (
'Table',
[Date]
= EARLIER ( 'Table'[Date] ) - 1
&& [Primary key] = EARLIER ( 'Table'[Primary key] )
),
[Sales]
)
return
[Sales] - _last
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |