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. Simple concept, but I'm not sure how to do it.
I have monthly data in a bar chart. If it is after the 15th of the month, I want to add 100 to the measure for the current month only.
This is an unsuccessful attempt (because it adds 100 to every month):
Solved! Go to Solution.
Hi, @bdeluca
Thank you for your feedback.
Please check the below picture.
Because today is 13th May, and in order to check whether the measure works or not, I input day=12 and it seems working properly.
Inside the sample pbix file, I input day = 15.
https://www.dropbox.com/s/ztmyqf0zkt7gks6/bdeluca.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi !
You can use following DAX to get the desired output;
New Measure =
VAR _CurrentYear = YEAR(TODAY())
VAR _CurrentMonth = MONTH(TODAY())
VAR _CurrentDay = DAY(TODAY())
VAR _SelectYear = MAX('Calendar'[Date].[Year])
VAR _SelectMonth = MAX('Calendar'[Date].[MonthNo])
VAR _SelectDay = MAX('Calendar'[Date].[Day])
VAR _AddToMeasure = IF(_SelectYear = _CurrentYear && _SelectMonth = _CurrentMonth && _CurrentDay >= 15, 100, 0)
RETURN
CALCULATE([Measure] + _AddToMeasure)
You are checking Current Year & Month from Today(), then you are validating if against Selected Year & Month if both are same & day is greater then equal to 15 than assign 10 else 0
You can then use this expression to add to your existing measure.
Regards,
Hi, @bdeluca
Please check the below picture and the sample pbix file's link down below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
So close!
My data is grouped by month. So I only want to add 100 to the total for the month (not 100 to each day).
Hi, @bdeluca
Thank you for your feedback.
Please check the below picture.
Because today is 13th May, and in order to check whether the measure works or not, I input day=12 and it seems working properly.
Inside the sample pbix file, I input day = 15.
https://www.dropbox.com/s/ztmyqf0zkt7gks6/bdeluca.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |