cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

Dax query it's really imp nd urgent for me

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 () )
)
)

 

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@greeshma 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

@greeshma 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

Super User III
Super User III

Hi @greeshma 

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 

 

SU18_powerbi_badge

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.

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

 

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.