Did you found a way to change the column header name based on the slicer selection?
@yekhtiari Жыл бұрын
Is it also possible to add month to the column so that we can have drill down functionality?
@KrishnakumarSaini-y7g Жыл бұрын
CAN WE DO SAME FOR MONTH AND IT SHOULD SHOW ONLY CUREEENT MONTH AND LAST MONTH ?
@myplace1982 Жыл бұрын
Can we extend this to show header for YTD and LYTD with year
@MiteshYadav Жыл бұрын
Hello, My dashboard gets updated every day. I am facing some issues implementing last quarter last week data. I need to show QTD, QTR current week , current quarter, previous quarter, and previous week data along with percentage on landing page. For eg. Suppose 2 weeks before it was quarter 1 and work week 13. From today quarter is changing to 2 and work week to 15. Now in previous week data for week 13 it is showing blank values . The problem is I am unable to create measure for last quarter last week data , where I need to show 13th week data, i.e., previous week. NOTE- I have a fiscal year calendar.
@ashokkumarpadmanabhan6483 Жыл бұрын
Good Demo !! Brother - Can you share Source file and Power BI File ?
@caleboud Жыл бұрын
instead of using max / min you can just use this var _Years = values(DATES[YEAR]) var _Calc = if( selectedvalue('Year In Use'[YEAR]) in _Years, _SalesQty, blank() )
@dikshasrivastava9125 Жыл бұрын
Blank is showing after creating sales ty and py measure. Why is it so
@meghab2910 Жыл бұрын
Suppose if we want month-year like jan- 23. In that how it possible
@TiênLêThịMỹ-t7y Жыл бұрын
Hi admin, Pls help me case Quarter. Exp: selected = Q3/2023 => show data Q3,Q2,Q1/2023. Thanks
@Lee16889 Жыл бұрын
suppose that my values inside the below measure CY30 SwitchACP = ( SWITCH(TRUE(), SELECTEDVALUE('TCOAP'[SwitchACP])=2,Maher[CY02 SW], SELECTEDVALUE('TCOAP'[SwitchACP])=3,Maher[CY03 Changed], SELECTEDVALUE('TCOAP'[SwitchACP])=4,Maher[CY04 CAL], SELECTEDVALUE('TCOAP'[SwitchACP])=28,Maher[CY28 SWGOPEX], SELECTEDVALUE('TCOAP'[SwitchACP])=25,Maher[CY25 SWNOPEX], SELECTEDVALUE('TCOAP'[SwitchACP])=22,Maher[CY22 SWTOPEX] ))/1000000 how can I create same your Dax ?