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 All,
I'm showing Sales MTD and Last Month Sales MTD week wise trend,for Last Month Sales MTD i'm having full data for last month and in current month my data is till 16.There,for Last Month Sales MTD the value is showing till month end instead of current month last date.There is no interaction between day and wise wise trend graph.
In the below picture,When I put Day with week Sales LM MTD is 2,058 but the total is 4,304 which is last full month sales instead of till 16.If I remove day and week as dimension ,week 3 Sales LM MTD is showing as 4,304 .It has to be 2,058.
DAX which I used is
Solved! Go to Solution.
Hi,
Does this measure help?
Sales LM MTD = CALCULATE([Sales MTD],datesbetween(dim_date[perioddate],edate(min(dim_date[perioddate]),-1),edate(max(dim_date[perioddate]),-1)))
This should work if the dim_date table goes only till today's date.
You are welcome.
Hi,
Does this measure help?
Sales LM MTD = CALCULATE([Sales MTD],datesbetween(dim_date[perioddate],edate(min(dim_date[perioddate]),-1),edate(max(dim_date[perioddate]),-1)))
This should work if the dim_date table goes only till today's date.
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |