Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
Is the column C possible to replicate on a Measure? The 85 is the total sum of 3 months (april, may, june). I just wanted to get the total value of a specific months.
Just comment out if you need more details.
Thanks!
Solved! Go to Solution.
Hi @EvanGetsItDone
Then modify it into 2 steps:
1. As you don't have a date column and your months are text, add a month number column:
2. Modify First Dax based on this column :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi,
Create a Calendar Table with a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table. Create calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number. To your visual, drag Year and Month name from the Calendar Table. Write this measure
Measure = calculate([sales],datesbetween(calendar[date],edate(eomonth(today(),-1)+1,-2),eomonth(today(),0)))
Hope this helps.
Hi,
Create a Calendar Table with a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table. Create calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number. To your visual, drag Year and Month name from the Calendar Table. Write this measure
Measure = calculate([sales],datesbetween(calendar[date],edate(eomonth(today(),-1)+1,-2),eomonth(today(),0)))
Hope this helps.
Hi @EvanGetsItDone
You can add a calculated column with a formula :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello,
Thanks for the response!
Sorry I may not have mentioned it. But I actually need the 3 months (including current month). It doesn't have to be a constant april, may, and june. I need a measure that would calculate the current month and the last 2 months.
Thanks!
Hi @EvanGetsItDone
Then modify it into 2 steps:
1. As you don't have a date column and your months are text, add a month number column:
2. Modify First Dax based on this column :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
80 | |
77 | |
64 | |
48 | |
45 |
User | Count |
---|---|
103 | |
45 | |
39 | |
39 | |
36 |