As of Date calculation Quarterwise

[Niraj_vora0106]

Hi community,

Is it possible to calculate As of month in Quarter?

Eg : April,May,June are a Quarter , but I want to calculate and show only June's value in Quarterwise chart.

Is it possible? 

[amitchandak · Accepted solution]

@Niraj_vora0106 , if you have selected a Qtr using date table, datesmtd will give last month

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(('Date'[Date])))

or try like

QTD Sales = CALCULATE(lastnonblankvalue('Date'[Year Month], SUM(Sales[Sales Amount])),DATESQTD(('Date'[Date])))

Year Month month should be in format YYYYMM

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...