Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
i have a table which has a sales qty field and the date of the sales.
i'm trying to have a formula to verify if the sales is in the current month, then dispaly the sum of sales per day in a graph.
please if any one has any suggestions.
thank you for your help.
Tony
Solved! Go to Solution.
Hi
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Hi
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Thank you All for your help.
Got it to work with your help.
regards,
Tony
Hi @Tonyk
You could create a measure
Measure = IF(MONTH(TODAY())=MONTH(MAX('Table'[date])),SUM('Table'[value]))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Here are a couple things that might help, can't be sure though given the current information:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
thx Greg,
i'll verify and let you know.
thank you