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 Community - I am utilizing the DAX patterns formulas at this link. Their example follows a specific column (order date).
However, I have three such dates I would like to create time intelligence formulas for. Order Date is one of them, but also Ship Date, and Due Date. Due Date comes from the Orders table (just as Order Date does). Ship Date comes from our Shipping Table. Of course I will need to connect these to my date table, which I have done already.
But my question is really around this formula below. This formula is specifically for the Order Date, but I need this same formula applied to all three date fields. I was hoping not to have to create three seperate measures. Is there a way to combine those three date fields into this formula? For example, if I want to create a YTD measure for Orders (based on Order Date, and another measure for shipments YTD (based on ship date), I'd like to just be able to reference the same "showvaluefordates" measure in both YTD formulas. Possible, or do I need to create, and reference, three distinct measures for each scenario?
Standard time-related calculations – DAX Patterns
Solved! Go to Solution.
@Anonymous,
You can create a calculation group to switch between dates:
https://www.sqlbi.com/articles/using-calculation-groups-to-switch-between-dates/
Proud to be a Super User!
@Anonymous,
You can create a calculation group to switch between dates:
https://www.sqlbi.com/articles/using-calculation-groups-to-switch-between-dates/
Proud to be a Super User!
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |