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.
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.
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |