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.
Hello All,
I have a table with shipments data & want to sum the amount of shipments for the previous day. So if today is Monday, I want to filter the table for Friday (Today -3) but if today is any other day, I just want to filter for the day before (Today-1).
I tried the below DAX but it didn't work:
Solved! Go to Solution.
Try something like this
MeasureVal =
VAR _weekday =
WEEKDAY ( TODAY (), 2 )
VAR _x =
IF ( _weekday = 1, 3, 1 )
VAR _result =
CALCULATE (
SUM ( 'Table1'[ShipmentAmount] ),
FILTER ( 'Table1', Table1[ShipmentDate] - _x )
)
RETURN
_result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Thank you all for the quick answers. I was able to make it work using:
Thank you all for the quick answers. I was able to make it work using:
@SJ25 , refer to my blog.
Create a rank on
Work Date = if(WEEKDAY([Date],2)>=6,BLANK(),[Date])
and use that. I have shown usage of rank on [Work Date Cont],
Now -1 rank will yesterday which is a working day
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Try something like this
MeasureVal =
VAR _weekday =
WEEKDAY ( TODAY (), 2 )
VAR _x =
IF ( _weekday = 1, 3, 1 )
VAR _result =
CALCULATE (
SUM ( 'Table1'[ShipmentAmount] ),
FILTER ( 'Table1', Table1[ShipmentDate] - _x )
)
RETURN
_result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |