Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone,
I have data with dates, category and values. now i need to show the values based on parameter selection.
To get the results of currentday(Today), I am getting the correct results based on the parameter selection.
Formula, which i used to get the results.
-----------------------------------------------------------------
Today =
var _date = SELECTEDVALUE(date[Dates])
var _today = CALCULATE(SUM(Table[Value]),FILTER(Table,Table[Dates] = _date))
RETURN
_today
----------------------------------------------------------------------
--date --> parameter
--Dates --> column
If i execute the similar formula for yesterday, results showing blanks and for one "category" showing previous date as different date.
I need to show the similar results for Today, Yesterday, Same period last year, week to date, month to date, Quarter to date
same period last year to date, Year to date.
Today | Yesterday | Same period last year | Week to date | Month to date | Quarter to date | sply QTD | YTD | sply YTD |
Results should be like this, Category is like a,b,c etc.,
Please help me . I am unable to fix the issue
@v-yueyunzh-msft @RasCZ
it will be a great help for me
@_AAndrade
I am unable to upload powerbi file. data is like almost similar to the image
Hi @Raj341,
Could you please share your pbix with same data so I take a look?
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |