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.
Hi - I'm new to DAX and would like some guidance to write something for a new measure:
Trying to come with a calculation
(If selected month is January then use January Measure
Else
Regular measure)
Solved! Go to Solution.
Hi there - this question is probably better being asked in the Desktop forum rather than Developer, as a lot more DAX experts frequent that particular forum and could help you faster than in here.
That being said, it should be a case of the following, assuming:
Syntax would be as follows:
[Conditional Measure] = IF( SELECTEDVALUE('Date'[Month]) = "January", [January Measure], [Regular Measure] )
It should be a case of swapping these out with your fields and measures as necessary.
Here's some further reading on SELECTEDVALUE (the SQLBI guys are pretty much essential reading for anyone who wants to learn DAX - you should make dax.guide a regular place to visit if you haven't already ;))
Good luck!
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi there - this question is probably better being asked in the Desktop forum rather than Developer, as a lot more DAX experts frequent that particular forum and could help you faster than in here.
That being said, it should be a case of the following, assuming:
Syntax would be as follows:
[Conditional Measure] = IF( SELECTEDVALUE('Date'[Month]) = "January", [January Measure], [Regular Measure] )
It should be a case of swapping these out with your fields and measures as necessary.
Here's some further reading on SELECTEDVALUE (the SQLBI guys are pretty much essential reading for anyone who wants to learn DAX - you should make dax.guide a regular place to visit if you haven't already ;))
Good luck!
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Thank you! that worked. Will post these kind of questions under Desktop forum from now on.