Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi All,
I need help in dax formula to achive below visuals.
I have below formula in my mind. But below formual will not work with DATE Slicer.
Please anybody can help me to write DAX formual to achive below figures.
TOTAL_MEAL_DAILY_CURRENT = CALCULATE (SUM(IFC_TAB[VALUES]),IFC_TAB[DATE_WID] = TODAY())
TOTAL_MEAL_DAILY_LASTYEAR =
TOTAL_MEAL_MONTHLY_CURRENT = CALCULATE (SUM(IFC_TAB[VALUES]),MONTH(IFC_TAB[DATE_WID]) = MONTH(TODAY()))
TOTAL_MEAL_MONTHLY_LASTYEAR =
TOTAL_MEAL_YTD_CURRENT = CALCULATE (SUM(IFC_TAB[VALUES]),YEAR(IFC_TAB[DATE_WID]) = YEAR(TODAY()))
TOTAL_MEAL_YTD_LASTYEAR =
Thanks & Regards
Jamsher
@jkhan - Not sure I am following this. Perhaps use ALL or ALLEXCEPT to override the Date slicer and then filter down from there?
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
@Greg_Deckler
Thanks for response. Below is sample data.
I need dax formula for below
meal count for current date
meal count for same date last year
meal count for current month
meal count for same month last year
meal count for current year
meal count for last year
Thanks & Regards
Jamsher