Dax query it's really imp nd urgent for me

[Anonymous]

hi can some one help me with this it is really very imp nd urgent for me

 https://drive.google.com/file/d/1BmG-flA6TE0v_sbka6rRtY0Aa2h8EsVT/view?usp=sharing 

i am using the below formulas to display my data for past 2 months nd current month based on month slicer selection

but i am unable to view my data.

can someone help me with dax query or a offset may also work to display my data.

R.SLA% 1 =

CALCULATE (

[M.SLA%],

FILTER (

'Query1',

'Query1'[Call Closed].[MonthNo] <= [month name]

&& 'Query1'[Call Closed].[MonthNo] >= [month name] - 2

&& 'Query1'[Call Closed].[Year] = YEAR ( TODAY () )

)

)

M.SLA% 1 =

CALCULATE (

[M.SLA%],

FILTER (

'Query1',

'Query1'[Call Closed].[MonthNo] <= [month name]

&& 'Query1'[Call Closed].[MonthNo] >= [month name] - 2

&& 'Query1'[Call Closed].[Year] = YEAR ( TODAY () )

)

)

[Fowmy · Accepted solution]

@Anonymous 

Your  [month name] is Text and Month.No 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[AlB]

Hi @Anonymous 

Can you explain a bit more what you exactly need?  Provide an example based an sample data and the expected result and the logic to get there

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

hiii aib

i am sharing u my pbix file nd expected output as well

i have a slicer in my data which has month names 

using that slicer selection my matrix and bargraphs should display sla% of current month selected which is working perfectly

now using the same slicer i need sla& mit sla% and count of call closed to display past 2 months nd current month data.

https://drive.google.com/file/d/1BmG-flA6TE0v_sbka6rRtY0Aa2h8EsVT/view?usp=sharing