then you can count the number of rows that have a value for last status. Have a similar problem where i am working with multiple calculated columns that need to switch based on slicer selection. If period=Year then "need a measure value which holds running total Year wise", else if Period = Quarter then "need a measure value which holds running total Quarter wise", else if Period = Month then "need a measure value which holds running total Month wise". Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, power bi: Aggregation of Distinct Count Measure. In the value field, drag and drop the name, month, Amount columns, and mom% measure from the field pane. Here we will see how to use distinct count function in power bi measure with example. Now the last step is to calculate the percentage of month over month, for this we need to divide the difference by the previous month value. Reza. Read Power bi Date Difference 8 Different Examples. Sounds like you need a calculated column, not a measure. All data analysts will have to deal with time. This is using the same approach that What-If parameter in the Power BI does, the only difference is that you create it yourself rather than through a graphical interface. You need to write a measure expression that based on the Selected Measure (the measure with the calculation above), returns the relevant measures value. You can also use Power Query to create a custom column. Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. Now we will calculate the desired status of the project within the time period(1/1/2018-30/06/2018), for we will follow the below logic: Now lets see how to implement the above logic to get the desired result using measure: Here we will see how to calculate measures based on two tables in power bi desktop. You can use all functions with YTD, MTD, and QTD in a similar fashion. And another table is the DimDate table which is a calculated table created by using the below function: Mom% formula = (This month- Previous month)*100/ Previous month. The YTD Total Sales measure uses a built-in DAX function called TOTALYTD. To apply conditional formatting, clicking on the down arrow of the Project > Conditional formatting > Background color. Dynamic Measure Selection in Power BI - Visual BI Solutions Power bi use date slicer value in the measure, Power bi measure for the sum of the previous month, Create a measure for average monthly sales power bi, Power bi buid a measure based of total of, Conditional formatting text based on measure, How to clear filters in a Measure Power BI, How to create a Measure based on Slicer in Power BI, Power bi measure subtract + 7 useful examples, Countif function in Power BI Measure + 10 Useful Examples, Power bi measure switch statement with examples, How to get selected value from Slicer in Power BI, Power bi show value as percentage + 13 Examples, Power bi Date Difference 8 Different Examples, Power BI Date Hierarchy Complete tutorial, Power BI MAX and MIN function with Examples, How to customize a SharePoint List form 5 Examples, Power BI DAX SUM and SUMX function How to use, Power BI Conditional formatting text based on measure, How to clear filters in a measure power bi.