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
please someone knows how to calculate the start or end of previous quarter?
Solved! Go to Solution.
@Anonymous
If you are creating a new column then
End of PQ = EOMONTH( ENDOFQUARTER( financials[Date] ) , -3 )
Start of PQ = EOMONTH( ENDOFQUARTER( financials[Date] ) , -6 )+1
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you both for your answer you saved my day =D thank you
@Anonymous
If you are creating a new column then
End of PQ = EOMONTH( ENDOFQUARTER( financials[Date] ) , -3 )
Start of PQ = EOMONTH( ENDOFQUARTER( financials[Date] ) , -6 )+1
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi rayloubai,
You can get by using below dax
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
hello @nvprasad
thank for your answer, but getting something weird, it displaying 2018
do you know how i can modify the script to have the normal year like the current one? 🙂
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |