I am not being able to write two DAX measures that bring me these:
Today = 04/25/2019
First Date of the Previous Quarter
Last Date of the Previous Quarter
Go to Solution.
@RafaelPassarell seems like you have date dimension in your model.
You can do something like this and add following for last date of prev quarter by changing MIN to MAX
First Date of PQ =
VAR myDate = TODAY()
CALCULATE( MIN( 'Date'[Date] ), PREVIOUSQUARTER( CALCULATETABLE(VALUES( 'Date'[Date]), 'Date'[Date] = myDate) ) )
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
Thank you @parry2k
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.