quickmeasure

2 Topics

n value in colum
Maximum Measure = MAXX(KEEPFILTERS(VALUES(TableNameOrColumnName)),CALCULATE(COUNTA(ColumnName))) Minimum Measure = MINX(KEEPFILTERS(VALUES(TableNameOrColumnName)),CALCULATE(COUNTA(ColumnName))) Pura vida! Maximun Original column named A, has the number 2 repeated 142 times (quickmeasure) Maximum Minumum Original column named A, has the number 28 repeated 1 times (quickmeasure) Minimum
Solved
Anonymous
4 years ago Place DAX Commands and Tips
1.7KViews
0likes
2Comments
YoY Quick Measure: How to get for only selected months instead of Jan-Dec?
Hello, I am using a quick measure to look at the previous years % change but the date it's looking at is from Jan-Dec when what I'm trying to get is only for the months of March-Feb. Here is the current DAX: PROJVOL YoY%= IF( ISFILTERED('data (3)'[period1]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI- provided date hierarchy or primary date column.") VAR __PREV_YEAR = CALCULATE( SUM('data (3)'[PROVJOL]), DATEADD('data (3)'[period1].[Date]. -1, YEAR) ) RETURN DIVIDE(SUM('data (3)'[PROVJOL]) - __PREV_YEAR, __PREV_YEAR) ) Any help would be greatly appreciated, thank you.
Solved
Anonymous
4 years ago Place DAX Commands and Tips
1.1KViews
0likes
4Comments