Measure to isolate specific field

Hi Creative_tree88 ,

Power BI has a whole set of Time intelligence functions, https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax , If you provide a link to a pbix file i can show you some examples with your data model

richbenmintz 
Apologies - how do I send you a link to a sampl of my work?

Hi Creative_tree88 ,

you can provide a link to a onedrive or google drive location

richbenmintz 
I've attached link to this message.  I've tried to show you what I've done so far, using the date from the website you advised.  Can't seem to master the month on month / previous month / % change etc, so hoping you can show me some examples using this data model.

As Previously mentioned, we measure Activity and Demand separately and I'd really like to know, from month to month, even week to week, which areas (Specialty Names) are increasing at the fastest rate / most numbers, on a real and % term basis.  Demand is particuarly useful for this sort of measure.  

Many thanks!  Power BI Sample 

Hi Creative_tree88 ,

First thing you need to do is replace the month value in your slicer with the month from your date table, then your count previous month will start to work, attached your file with that simple mod

richbenmintz 
That works well, thanks for pointing that out.  Is there any way of adapting this table to show (in the data model I gave you the link for) which 'Modality' has increased the most (in numbers and in % terms) based on last month, last week and this time last year??  If you could show me how this is done, I think I'd be able to roll this out for all the other measures I need to show in my work?  Many thanks for all your help thus far!  Kind regards

Hi Creative_tree88 ,

I have added a few more measures and added a new calendar that includes weeks. see attached

richbenmintz - thanks for this, really helpful indeed!  I am still really struggling to be able to visualise and 'pick out' the 'AD_Modality which has increased the most, over a month or week basis.  How can this be achieved?

Hi Creative_tree88 ,

Try using the conditional formatting option

richbenmintz - I don't know how to do that, unfortunately, and relate it to 'AD_Modality'.  Every time I bring AD_Modality into the table, it goes blank so getting confused as to how this is done, given the tables you've done, relate specifically to month and week dates, not AD_Modality fields...bit flummoxed to be honest.  If you had time, I'd really appreciate if you could show me a visual, based on your month change table, which highlights which AD_Modality has increased the most from this month to last month...?  I think once I know how to do this, the rest should be more straight forward.  Kind regards

Hi Creative_tree88 ,

I have created a rank measure which I used to apply conditional formatting of a measure value, see below

you find conditional formatting in the values area, drop down of value.

modified pbix attached

richbenmintz - many thanks for your help with this, having used Qlikview for so long it's difficult to know where everything is and the subtle differences can actually be quite large when you come to use them!  Really appreciate your time with this - I'll study this sample file and hopefully get to grips with it all.  If I have any problems, is it OK to call on you?  Kind regards

richbenmintz
I've created some tables, based on this formatting and works well.  However, I'd like to try and take this a step further by creating some sort of text box with the highest month-on-month change in numbers (not %) - current full month to previous month would be ideal as looking for peaks / stresses in terms of spiking demand within our business.  Rather than sifting through lots of tables and clicking, how can I create more of a headline dashboard text box type thing which basically says 'MRI has increased the most this month - x vs y last month'...?  I can then re-create this for the specialty and exam fields (which are not included in the sample data, but which I can do myself, once I know how to do it for AD_Modality in the same data I linked for you.  

Once I can see which areas have spiked the most, in numbers terms, month on month, it will allow me to focus in on this specific area, without trying to find it manually by clicking on the table to find it.  These tables are fantastic, but a headline text box telling me exactly where the month on month demand growth is (current to previous month) is perfect.  

I've got this so far, but all it does really is show me the highest change per month overall, not on a 'current month to previous month' basis...?

Really hope you can help!  Rgds

richbenmintz - is there any chance you could help me with this current problem, regarding creating a 'card' on the report which tells users which modality (AD_Modality) has increased the most, based on current to previous month change?  Kind regards

Hi Creative_tree88 ,

Will try to have a look today 

richbenmintz - thank you so much.  Really appreciate it.  Kind regards

richbenmintz - that solution works really well!  Many thanks indeed.  I guess I can tailor it to show fields other than modality i.e. Specialty, Exam etc etc....just by tweaking the script?  Very much appreciate all your help.  Kind regards