Forum Discussion
Power bi matrix
HI MHTANK ,
What do you mean by import file in power bi?
The sample data on my side has a Date type column named Date, not sure how you configure your data.
Best Regards,
Qi
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
We want to help you but your description is too vague. Please write it again clearly.
Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Remove any unneeded columns which may cause confusion.
Rename columns to user friendly names. Avoid your business or system jargon that we may not understand.
Also provide the example desired output, with a clear step-by-step description of calculations the process flow.
For example from when is 15 days, 1 month and 2 months derived? Is it the most recent date on the table or the system date?
How is the 3, 27 and 1005 caculated?
Give a clear step by step description. Do not post Excel or DAX formulas. Just describe it is plain language. Thank you.
Remember not to share private data ... we don't want you to get into trouble.
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.
Try keep it simple and ask one question per ticket.
You will get a quick response if you put time, care and effort into writing clear problem descriptions with example data.
Look forward to helping you when the above information is forthcoming
3 is count of Ref No. ,27 is average of Days and 1005 is sum of value