Day, Week, Month Wise values in Matrix

Question

Hello All,&nbsp;We have a requirement, That is if we selected days, weeks, months in slicer(relative date),Present we adjusted in Day wise spent time in Matrix Visual. If we selected week need to convert into week wise report same like for month also.&nbsp;Is any possibility with Dax. Please tell me the right aprroach. For reference please check the imags below.&nbsp;&nbsp;Thanks in Advance,&nbsp;

jihwan_kim · Answer

Hi,&nbsp;jay_patel&nbsp;Please check the below picture and the sample pbix file's link, whether it is what you are looking for.&nbsp;The measure is in the sample pbix file.&nbsp;&nbsp;https://www.dropbox.com/s/um2aye0h4tqdia3/jaypatel.pbix?dl=0&nbsp;&nbsp;Hi, My name is Jihwan Kim. &nbsp;If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up. &nbsp;Linkedin: https://www.linkedin.com/in/jihwankim1975/

jay_patel · Answer

Hi,&nbsp;Jihwan_Kim&nbsp;Thanks for reply,But getting error while creating measure.&nbsp;"USERELATIONSHIP function can only be used in the CALCULATE function."

jihwan_kim · Answer

Hi,&nbsp;jay_patel&nbsp;Sorry, I could not understand what you want to describe.please write DAX measure same (or similar) as mine.Thanks.&nbsp;Hi, My name is Jihwan Kim. &nbsp;If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up. &nbsp;Linkedin: https://www.linkedin.com/in/jihwankim1975/

Forum Discussion

Day, Week, Month Wise values in Matrix

3 Replies

Related content

PowerBI - Matrix table, hide values used only for a visual calculation

Sum Values in Matrix based in another value in that matrix

Matrix with dynamic values

Calculate previous week values

Matrix table