Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there,
i have a table that contains 3 columns
1 - "Conteggio Scontrini" -> trad: Count Receipts
2 - Date
3 - "Carta" -> Fidelity Card No_
Each row shows how many receipts were issued that day for that fidelity card.
I would like to have from this table a representation something like Pivot.
Example below in Excel.
So, how many fidelity cards have a receipt, how many 2, how many 3, etc etc etc.
Taking the dates into consideration, it must therefore be not static but dynamic data
Please help me
All the best
Hi @Z_BI ,
In the report view select matrix or table in visualization and add Conteggio Scontrini,Carta in columns. Then right click on feild and select "count". similarly you can add filter from visualization, add date into it.
Thanks
Hi @Mani_1 ,
thnx to reply.
If I do what you show me the results is not good.
Applicated COUNT in "Conteggio di carta". I need to have "COUNT RECEIPES" divied
1
2
3
4
etc etc
Sure, here below.
Table dates
In report, at the moment, i have this visual
Field "Carta" - no summerize
Filed "Conteggio Scontrini" - SUM
my need, in a simpler way, is to answer this question: "in a given period of time I select how many loyalty cards have had a receipt? How many 2? and so on....
Let me know if you somenthing
thanx for your support
All the best
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
109 | |
107 | |
92 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |