The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a table, where i want to create a measure in DAX which calculate the cost of the items only if both of the two conditions are met, when today is after or equal to the pick up date and when today is less than or equal to the drop off date. I am not getting the right answer, could someone please advice.
items | Pick up date | Drop off date | cost |
1 | 01/01/2024 | 03/01/2024 | £5 |
2 | 02/01/2024 | 07/01/2024 | £10 |
3 | 03/01/2024 | 10/01/2024 | £15 |
Solved! Go to Solution.
Hi @Anonymous ,
Could you please try below DAX to create a measure :
Hi @Anonymous ,
Could you please try below DAX to create a measure :