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.
Hi guys,
I'm stuck. Please help out.
So, I'm having a dataset, with Opportunities and their Close Dates, Amount Non-Weighted, and Amount Weighted.
I'd like to have a formula in a column saying: if Close Date is in the CURRENT QUARTER, then Amount Non-Weighted, else Amount Weighted.
Thank you so much.
Alice
Solved! Go to Solution.
Hi,
Try creating a calculated column like something below and see if it helps
CalcColumn =
IF( YEAR( 'Table'[Close Date] ) & QUARTER( 'Table'[Close Date] ) = YEAR( TODAY() ) & QUARTER( Today() ),
'Table'[Amount Non-Weighted],'Table'[Amount Weighted] )
Hey @AliceW ,
I would use an if like in a calculated column like:
if = if(quarter([Date])=Quarter([Now())," Amount Non-Weighted","Amount Weighted")
Let me know if it helped, if so mark as solution.
Best Regards,
Duarte Raminhos
Hi Duarte,
I can't seem to find QUARTER in the function list.
Hi,
Try creating a calculated column like something below and see if it helps
CalcColumn =
IF( YEAR( 'Table'[Close Date] ) & QUARTER( 'Table'[Close Date] ) = YEAR( TODAY() ) & QUARTER( Today() ),
'Table'[Amount Non-Weighted],'Table'[Amount Weighted] )
Hi Gordon,
Based on your suggestion, I figured it out. for some reason, QUARTER is not available in my list of functions, but I did use FORMAT(TODAY(),"Q").
Thank you!
Alice
Good to hear that you solved it.
The quarter function came with the 2019 december update so perhaps you don't have the latest version
They have finally added the Quarter function? Hourray! I'll download it now - you were right, I did not have it.
Thanks again, Gordon!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |