sum of a field per day for current month

[Tonyk]

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

[v-juanli-msft · Accepted 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

[Tonyk]

Thank you All for your help.

Got it to work with your help.

regards,

Tony

[v-juanli-msft]

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.

[Greg_Deckler]

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

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Tonyk]

thx Greg,

i'll verify and let you know.

thank you