User Profile
Avermaak
Helper I
Joined 4 years ago
User Widgets
Contributions
Unit Slicer Help
I need some assistance with converting the display units in my visual, from normal amount to Thousand or MIL using a slicer. Normally you adjust your visual by changing the display units in the Visualizations editing options or by using a button and bookmark to change the visual when selecting it, but I would like to achieve this with a DAX formula and slicer as there are too many visuals and too many bookmarks already. I would not like to slow down my model. What I have done so far: I have created a slicer table for the slicer pane: Then I created a column in my data with Display Units I then created a relationship between the two: Then I created a formula to filter the values when I select the appropriate display Unit: Unit Format = VAR SelectedOption = SELECTEDVALUE(Billable_COE[Display Units]) VAR Multiplier = LOOKUPVALUE('Unit Slicer'[Multiplier], 'Unit Slicer'[Display Units], SelectedOption) VAR SummaryTable = SUMMARIZECOLUMNS( 'Billable_COE'[Ad Hoc Bonus], 'Billable_COE'[Billable COE], 'Billable_COE'[Business Intitiatives], 'Billable_COE'[Business Support], 'Billable_COE'[Corporate Social Resp], 'Billable_COE'[General Admin & Mng], 'Billable_COE'[Learning & Development], 'Billable_COE'[Leave & PHO], 'Billable_COE'[Market and Brand Development], 'Billable_COE'[Outstanding Timesheets], 'Billable_COE'[Overtime], 'Billable_COE'[Proposal and Client Engagment], 'Billable_COE'[Rate Differences], 'Billable_COE'[Wages Non Billable], "CalculatedValue", SUM('Billable_COE'[Billable COE]) / Multiplier ) RETURN MAXX(SummaryTable, [CalculatedValue]) But unfortunately it is not working..... can someone please help me as I am not sure what I am doing wrong.Day to day Difference
Good day, I am trying to calculate the day to day difference based on weekdays only, for my daily banking movement. I have would like the table to look as follows: I used the following formula to calculate the difference but it does not take into account the weekends, how can I change my formula to exclude the weekends from the calculations and only base it on weekdays. Movement = VAR __PREV_DAY = CALCULATE( SUM('BST_INPUT'[Per Collect]), DATEADD('BST_INPUT'[Date],1,DAY) ) RETURN SUM('BST_INPUT'[Per Collect]) - __PREV_DAY3 Month Rolling Graph
Good day, I am experiencing some issues with a 3 month rolling graph I did, I am trying to do a 3 month rolling amount for each of the 6 first columns, per period, I have added a fiscal period Running number into my date table, but every 12 months the count restarts, and i dont want it to restart. Below some screenshots. Could someone please help me. This is the formula I used: This is the test I did to show where I get differences on the 07th and 08th Period and the 12th and 1st period. No need for further assistance, the fiscal running period was not pulling correctly, when I fixed it the problem was solved.
