Forum Discussion
Dynamic Measure for Card Visual
Hi Anonymous
1 Create DimDate
Dim_Date = VAR MinDate = MIN(Traxx[session_date]) VAR MaxDate = MAX(Traxx[session_date]) RETURN ADDCOLUMNS( CALENDAR(MinDate, MaxDate), "Day", DAY([Date]), "Month", MONTH([Date]), "MonthName", FORMAT([Date], "MMMM"), "Quarter", "Q" & QUARTER([Date]), "Year", YEAR([Date]), "YearMonth", FORMAT([Date], "yyyy-MM"), "MonthYearShort", FORMAT([Date], "MMM-yy"), "IsWeekend", WEEKDAY([Date], 2) > 5 )
2 Create measures
Current RED Score = CALCULATE( AVERAGE(Traxx[KPI]), Traxx[kpi_name] = "Red Score" )
Previous RED KPI = VAR CurrentDate = MAX(Dim_Date[Date]) // Gets the current date from context VAR PreviousMonthStart = DATE(YEAR(CurrentDate), MONTH(CurrentDate) - 1, 1) // Start of previous month VAR PreviousMonthEnd = EOMONTH(PreviousMonthStart, 0) // End of previous month RETURN CALCULATE( AVERAGE(Traxx[KPI]), Traxx[kpi_name] = "Red Score", Dim_Date[Date] >= PreviousMonthStart, Dim_Date[Date] <= PreviousMonthEnd, REMOVEFILTERS(Dim_Date[MonthYearShort]) // Clears the current month filter )
Growth % = DIVIDE( [Current RED Score] - [Previous RED KPI], [Previous RED KPI], 0 // Returns 0 in case of division by zero )
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
I want to help you but your description is too vague. Please write it again.
You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming
* Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want. (That is just crazy).
* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble.
* Please click the thumbs up button for these helpful hints and tips. Thank you.
Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.
Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.