HELP!! Add period 0 to calculation without putting it in slicer
Hi everyone, I've been running into a problem for a while now. I am currently working on a financial balance sheet. Currently my dataset consists of the following columns: - Description - Year_Open - Period credit (These are the changes to the opening value) - Period debit (These are the changes to the opening value) - Period (1 to 12 months) As can be seen in the photo above, the opening value is not a period, I wanted to give it the period 0. This made me want to create the formula: Period 0 + selected period in slicer. Does anyone know how I can create this formula in DAX? I also have to ensure that the period 0 is not visible in the slicer, how can I do that? However, I am not very good with DAX formulas and so far I have solved it as shown below. Only then will the total not change if I adjust the slicer, even though this is a requirement. Credit = VAR PeriodCredit = SUM( 'Balance'[Year_Open]) + SUM('Balance'[Period_Debit]) - SUM('Balance'[Period_Credit]) VAR Scoop = NOT(ISINSCOPE(KPI_EOL_xml_GLAccountClassifications[GLClassification2_description])) VAR ScoopPeriodCredit = SUM(Balance[YearClosedCredit]) VAR Result = IF(Scoop,ScoopPeriodCredit,IF(PeriodCredit < 0, - PeriodCredit)) Return Result Hopefully someone can help me with this! Thanks!
Max Value for Score of Same Date
Hi, I have a table that contains a DATE & Score. However, I want to be able to get the highest score [Expected Result] of that day and apply it in a seperate column as shown below: DATE Score Expected Result: Max Score for Date 4/1/2023 10 40 4/1/2023 20 40 4/1/2023 30 40 4/1/2023 40 40 5/9/2023 2 2 5/10/2023 1 5 5/10/2023 5 5 5/11/2023 6 6 5/12/2023 5 7 5/12/2023 7 7 Is there a way to have this in a Calculated column and not measure?
