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 All,
I have a requirement , I want to calculate current month amount of current year.But when i will select other month(not current month) from List Box filter then report should show that month amount.
So I want a variable base amount . bydefault report will show current month amount but when some other month select than other month amount should show in report.
Thanks
Narender
Solved! Go to Solution.
Hi @Narender,
Here I made an sample for your reference.
Measure = IF(ISFILTERED(Table1[Month]),CALCULATE(SUM(Table1[sales])),CALCULATE(SUM(Table1[sales]),FILTER(Table1,MONTH(Table1[Date])= MONTH(TODAY()) && YEAR(Table1[Date])=YEAR(TODAY()))))
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Narender,
Here I made an sample for your reference.
Measure = IF(ISFILTERED(Table1[Month]),CALCULATE(SUM(Table1[sales])),CALCULATE(SUM(Table1[sales]),FILTER(Table1,MONTH(Table1[Date])= MONTH(TODAY()) && YEAR(Table1[Date])=YEAR(TODAY()))))
For more details, please check the pbix as attached.
Regards,
Frank
Hi Frank,
Thank you. It is workig for me.
Can you please tell me 1 more thing ?
how can I apply the same with Quarter. "Calculate current Quarter amount if no selection on month list box".
Thanks,
Narender
Hi @Narender,
Please try to use the formula.
Measure2 = IF(ISFILTERED(Table1[Month]),CALCULATE(SUM(Table1[sales])),CALCULATE(SUM(Table1[sales]),FILTER(Table1,FORMAT(Table1[Date],"q")= FORMAT(TODAY(),"q") && YEAR(Table1[Date])=YEAR(TODAY()))))
Regards,
Frank
Hi Frank,
I am using below measure for quarter.But it is not showing right data.
Measure 5 = if(ISFILTERED(Dates[Month]),CALCULATE(COUNT(DOCUMENT[DOC_NO]),DOCUMENT[Flag_Doc]="A"),CALCULATE(COUNT(DOCUMENT[DOC_NO]),DOCUMENT[Flag_Doc]="A",FILTER(Dates,FORMAT(Dates[Date],"q")= FORMAT(TODAY(),"q") && Dates[Year]=YEAR(TODAY()))))
Thanks,
Narender
Hi @Narender,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
Hi @Narender
Could you try using this measure?
Assuming, you have a date table named Date..
Sum = IF (ISFILTERED ( 'Date'[Month] ),
CALCULATE(SUM(Table[Column])),
CALCULATE (SUM(Table[Column]), Date[Month] = MONTH(TODAY()) && Date[Year] = YEAR(TODAY()))
Let me know if this works or not.
Thanks,
Suguna.
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |